Bring up data via either of 2 combo boxes

[st3ve]

NOT Cascaded - Bring up data via either of 2 combo boxes

OK the first part i can do (ie Bring up data via either combo box)..
For example i want to be able to select a person by their name or by their code number.
I am using recordsetclone statement to pull up the data at present....

But how do I get the second combo box to display the 'matching' data when a value from combo box 1 has been selected, and also vice versa.

ie. When I select "Joe Bloggs", I want to see "Joe Bloggs's" code number correctly shown in the code number combo box.

Your ideas all welcome.

Thanks.

 

[___]

Do a search here on cascading combo boxes, there are many posts on the subject.

 

[st3ve]

NOT cacscading my combo boxes

Yeah, I thought of that, thanks. but I'm not trying to cascade my combo boxes.......

I want to search by 2 (or more) alternative methods and have the non-searching box(es) show the matching data correctly. I'll have a look through the cascading posts anyway, just in case.

Thanks.

 

[Jimused]

You could create a query that uses the input from the first combo box as the criteria for selecting records then make the query the row source for the second combo. More details if this sounds like what you want.