Multiple Feild Selections in list box

[KeithB13]

Hello,

I am having trouble with a list/combo box on one of my forms. The form is running from a table that has multiple key fields(three to be exact).

Anyway, when I use a list box or combo box for a seach, it always brings up the first record with matching criteria for one field only.

I have 3 fields in my list box and I would like to use all three as criteria for record lookup.

How do I set up a list/combo box to display a record based on three fields?

Thanks,
Keith Bledsoe

 

[namliam]

take a look at the column property of a list/combo box

Using that you can reference other columns from the box. Then use YourKey1 = cbbox.Column(0) and YourKey2 = cbbox.column(1) and yourkey3 = cbbox.column(2) to find your right record

I hope it helps..

Regards