I'm using a table as its own lookup table in a form. That works fine, but when I'm trying to use the DLOOKUP to get the text instead of ID number I keep getting an error. Here is the function I'm using:
=DLookUp("[facid]","[FACILITIES]"," [ID]=[facadj1] "
Everything here is from the same table FACILITIES. ID is the PRIkey using Autonumber. facid is the identifier I want to show on my report. facadj1 is the field where where the ID number is stored. Any help will be appreciated.
Thanks,
Tony
=DLookUp("[facid]","[FACILITIES]"," [ID]=[facadj1] "
Everything here is from the same table FACILITIES. ID is the PRIkey using Autonumber. facid is the identifier I want to show on my report. facadj1 is the field where where the ID number is stored. Any help will be appreciated.
Thanks,
Tony