combo box search

[Martin]

Hello, I have a combo box on a form named cmbSearch, it
has three columns pulling from a table, column one is
named FirstName, column two is named LastName and column
three is named EmployeeNo. My question is how can I get it
so that when the user clicks on any name in the combo box
the specified record pops into the text boxes on the form?
Thank You,
Martin

 

[Dan Artuso]

Hi,
Build your combo with the wizard, it will generate the code for you.
Just make sure that EmployeeNo is the first column.