ComboBox

N

Neil Greenough

I have set up a search combobox in the header of my contacts form.
Basically, I want to choose a contact from the combobox and then for their
contact details to appear in the detail part of the form.

In the row source, I have the following:-

SELECT [Contacts].[EmployeeID], [LastName] & ", " & [FirstName] AS FullName,
[Contacts].[LastName], [Contacts].[Firstname] FROM Contacts ORDER BY
[LastName] & ", " & [FirstName];

Nonetheless, when I choose a name from the dropdown menu, I remain on the
same contact and the details don't change.

I don't have nothing in the control source box - should I?

I have got this to work on other forms and have just copied the same format
but changed the table names, however it still isn't working.
 
K

Ken Snell [MVP]

Is the form's RecordSource a query that uses the combo box as the source of
the criterion value? Also, you must tell the form to requery itself in the
AfterUpdate event of the combo box.
 
Top