Selecting Data from List Box

[Denburt]

I know I am busting in here but I think you need to look at the following line and make sure the "ID = " is named the same as the field in the database, from the appearance of things it might be [Customer ID]

DoCmd.OpenForm "Current_Custom er_Data", , , "[Customer ID]
= " & Me.lstSearchRes ults.Column(0)


See where I am going this might just resolve your issue.

[NeoPa]

If that doesn't solve your problem (It probably will), look at the data type of the [whatever ID] field. If it is not numeric then we'll need to look again.
A further couple of points which you can use or ignore...

1. Row Source Type (As Rabbit said earlier) should replace Row Source in your code that sets it to 'Value List'.
2. You should maybe consider using a Table/Query type anyway.
   There is an option to show 'Column Heads' and it would mean you could lose a whole chunk of clumsy code.

Just some thoughts.

[UAlbanyMBA]

Thank you both, it works!! I really appreciate it. I don't doubt this will be the last post, but once again thank you.

[NeoPa]

No problem. Pleased to be of use :)

[Denburt]

Glad to know your good to go... :)