combo box not selecting

D

Debbie S.

My intent is to create a combo box on a form that will allow the user to
choose a name from the combo box (ordered as last name, first name), and when
you click on that name, the form goes to the record that holds that name. I
was able to create the combo box, and I can choose a name from it, but it
does not go to the record associated with that name. Any help would be
appreciated. Thanks. --ds
 
F

fredg

My intent is to create a combo box on a form that will allow the user to
choose a name from the combo box (ordered as last name, first name), and when
you click on that name, the form goes to the record that holds that name. I
was able to create the combo box, and I can choose a name from it, but it
does not go to the record associated with that name. Any help would be
appreciated. Thanks. --ds
Click to expand...

You haven't given us any idea of the code behind the combo box that
tells it to do what you want to do.

I would suggest you start all over again.
On a bound form, add a combo box (to the form header) using the wizard
(the tool box button with the wand and stars should be down).
Select the 3rd option, 'Find a record ... etc'. Follow the wizard
instructions.
When you are done, select a value in the combo box. The record
associated with that selection should appear on your form.
 
D

Debbie S.

Duh! Thanks. It's working now.

fredg said:
You haven't given us any idea of the code behind the combo box that
tells it to do what you want to do.

I would suggest you start all over again.
On a bound form, add a combo box (to the form header) using the wizard
(the tool box button with the wand and stars should be down).
Select the 3rd option, 'Find a record ... etc'. Follow the wizard
instructions.
When you are done, select a value in the combo box. The record
associated with that selection should appear on your form.
Click to expand...
 
Top