Multiple DLookUp Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry - I've had to enter this again as for some reason I can't view my
original post NOR the response (even using the hyperlink)

I am trying to 'display only' the key contacts on a tabcontrolpage by using
the code below. This works though there are some instances where there is
more than one key contact for an organisation.

Can I change this expression to display multiple contacts or is there a way
I can have another filed that extracts the 2nd contact or 3rd contact etc.?

=DLookUp("OrgContact","ContactsOrg","ContactID = " & [ContactID])
=DLookUp("OrgContact","PositionOrg","ContactID = " & [ContactID])

TIA
 
To display multiple items use a list box.

The Row Source will be something like this:
SELECT OrgContact FROM ContactsOrg
WHERE ContactID = [Forms].[Form1].[ContactID];
 
Back
Top