Combobox Help

[Guest]

I have a combo box on a form that displays the user's Last name and First Name. The way I have it now if a user double clicks on the combo box it brings up another form that displays all of the information from the user table, beginning with the first record in the table. What I would like to have happen is when a user double clicks on the combo box it brings up only the displayed user from the combo box.

This is the select statment from the combo box
SELECT [USER_lname] & ", " & [USER_fname] AS Team_lead FROM USER_lkup WHERE USER_lkup.USER_type="Team Lead" ORDER BY USER_lkup.USER_lname, USER_lkup.USER_fname

Any suggestions?

 

[Byron]

Take a look at the OpenForm action that you are using to
open the form. Specifically look at the Where option that
can be used when opening the form. You can read the
information from the combo box and then use that to open
the form to the record for the selected item.

HTH

Byron

-----Original Message-----
I have a combo box on a form that displays the user's

Last name and First Name. The way I have it now if a
user double clicks on the combo box it brings up another
form that displays all of the information from the user
table, beginning with the first record in the table.
What I would like to have happen is when a user double
clicks on the combo box it brings up only the displayed
user from the combo box.

This is the select statment from the combo box.
SELECT [USER_lname] & ", " & [USER_fname] AS Team_lead

FROM USER_lkup WHERE USER_lkup.USER_type="Team Lead"
ORDER BY USER_lkup.USER_lname, USER_lkup.USER_fname;

 

[Mike Painter]

Take a look at the OpenForm action that you are using to
open the form. Specifically look at the Where option that
can be used when opening the form. You can read the
information from the combo box and then use that to open
the form to the record for the selected item.

HTH

Byron

You can also base the form on a query that selects just that person.
Forms!YourFormName!ComboBoxName as the criteria for the ID of the record.