ComboBox

[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.

 

[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.