Not bring up details

[Neil Greenough]

I have set up a contacts table/form. In the header of my contacts form, I
have the following:

SELECT [ContactsEcho].[EmployeeID], [Surname] & ", " & [Forename] AS
FullName, [ContactsEcho].[Surname], [ContactsEcho].[Forename] FROM
ContactsEcho ORDER BY [Surname] & ", " & [Forename];

This works fine and all my contacts are listed in this list. Nonetheless,
when I select a contact, there details are not brought up in the form. What
am I doing wrong? When I select the relevant person, their name just becomes
listed in the search menu and nothing else. What I want is for the form to
then automatically bring up that specific individual's contact details.

Kind regards

 

[Neil Greenough]

Apologies all - I have just learnt the joys of a combo box.