LookUp Functions

[John Drake]

Hi
I need help with LookUp. I have used DLookUp() but this doed not work as
this gives me the wrong information. The field information is correct but it
is for the wrong record. How does Href (?) work?

Regards
John

 

[Allen Browne]

John, use the 3rd argument to identify the record you need.

If you are getting the answer from the wrong record, you have not supplied
enough information in the Criteria, perhaps?

 

[ghetto_banjo]

Instead of using those functions, have you looked in to using
RecordSets? Not sure what you are trying to accomplish exactly.

 

[Keith Wilby]

Hi
I need help with LookUp. I have used DLookUp() but this doed not work as
this gives me the wrong information. The field information is correct but
it
is for the wrong record.

Did you know that DLookup has a "Criteria" argument?

Keith.
www.keithwilby.com