LookUp Functions

  • Thread starter Thread starter John Drake
  • Start date Start date
J

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
 
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?
 
Instead of using those functions, have you looked in to using
RecordSets? Not sure what you are trying to accomplish exactly.
 
John Drake said:
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.
Click to expand...

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

Keith.
www.keithwilby.com
 
Back
Top