Not bring up details

  • Thread starter Thread starter Neil Greenough
  • Start date Start date
N

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
 
Back
Top