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