Query problem

[Jenny1]

I have a form which has a combo box, the dropdown list in this combo box is populated with surname, givename for each contact.

When user begins to enter surname the list pulls up the record - user presses enter OR selects value from list and the text boxes on the left are populated with data relating to that record.

This works fine BUT only when user enters the surname. What if a user only remembers the first name?

So i figured that Ill copy the combo box but change the order of the uqery to search for givenName first.

This works fine and data is populated in the combo box BUT When I press enter OR select the value from the list it pulls up a randomn record sand not the one I entered.

Any ideas.

The form is called ViewPerson. The combo box on top works fine the new one below it doesnt?

Your advice please - file attached

 

[motleyjew]

You copied the combo box, but you didn't copy the the code that was in the after update event. Try this.

 

[Jenny1]

thanks, thats sorted.