B
Brian Goodheim
I am using a lookup field in a primary table which uses a combo box to
lookup contact personnel in a secondary table. The lookup field uses a
Table/Query row source to populate a combo box on the datasheet which is
supposed to return only personnel working for the client of the active
datasheet record.
However, the combo box is populated with personnel form every client. When I
enter text as criterea, the query works fine. But I can't get just the
current client's contacts to display by entering the field name as criterea.
I've tried entering the following as criterea, not knowing a lot about
access syntax conventions:
Assignments.ClientID
[Assignments].[ClientID]
Assignments!ClientID
[Assignments]![ClientID]
Me!ClientID
Me.ClientID
What I am trying to do is get access to use the contents of the ClientID
field in the primary table as criterea to filter the contacts from the
secondary table. Does anyone know what I'm doing wrong?
Thanks,
-Brian Goodheim
lookup contact personnel in a secondary table. The lookup field uses a
Table/Query row source to populate a combo box on the datasheet which is
supposed to return only personnel working for the client of the active
datasheet record.
However, the combo box is populated with personnel form every client. When I
enter text as criterea, the query works fine. But I can't get just the
current client's contacts to display by entering the field name as criterea.
I've tried entering the following as criterea, not knowing a lot about
access syntax conventions:
Assignments.ClientID
[Assignments].[ClientID]
Assignments!ClientID
[Assignments]![ClientID]
Me!ClientID
Me.ClientID
What I am trying to do is get access to use the contents of the ClientID
field in the primary table as criterea to filter the contacts from the
secondary table. Does anyone know what I'm doing wrong?
Thanks,
-Brian Goodheim