combo box search

M

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Combo Box Listing 5
RecordSet.FindFirst 2
Based on value from 1 combo box filter results in the next combo b 2
Combo Box Default Value 4
Simple combo box 2
Combo Box in a Datasheet Form 2
Copying Records from a form to a table 1
Using a Combo Box for Filtering a Continous Form 1

Top