combo box search

  • Thread starter Thread starter Martin
  • Start date Start date
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
 
Hi,
Build your combo with the wizard, it will generate the code for you.
Just make sure that EmployeeNo is the first column.
 
You must log in or register to reply here.

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

Based on value from 1 combo box filter results in the next combo b 2
Combo Box Default Value 4
Combo Box in a Datasheet Form 2
Filter Combo Box Listing 5
RecordSet.FindFirst 2
Drop Down Search Box 2
Use a combo to filter records on a form 5
VBA code for unbound column in combo box 3

Back
Top