J
Jim Dudley
I have a form based on a crosstab Query.
I want to add some additional data from another table based on a key
identifier matching the same record. The Primary Key also exist in my source
table for lookup.
The Dlookup returns the correct data on the first record but also returns
the same data for all other records in the query.
The dLookup is contained in an unbound text control in my form.
=NZ(DLookUp("[L1]","WStuContacts","[Snum]=SNum"))
[Snum] resides in the form from the query and [SNum] is also a Primary Key
in the WStuContacts Table.
Any suggestions would be appreciated. I am a beginner at this....
Thank you.
I want to add some additional data from another table based on a key
identifier matching the same record. The Primary Key also exist in my source
table for lookup.
The Dlookup returns the correct data on the first record but also returns
the same data for all other records in the query.
The dLookup is contained in an unbound text control in my form.
=NZ(DLookUp("[L1]","WStuContacts","[Snum]=SNum"))
[Snum] resides in the form from the query and [SNum] is also a Primary Key
in the WStuContacts Table.
Any suggestions would be appreciated. I am a beginner at this....
Thank you.