lookup table (Access 2000)

Topic

New Reply

How to look up in a table depending on an option

I have a tables called Affiliates with the following order

afid,CompanyName,City

I have a form called F1.
I have made the following code which didnt work:
If Forms![F1]![Office] = 1 Then
Forms![F1]![labelOffice].Caption = DLookup(“Affiliates”,”City”, afid = 1)
End if

Can somebody tell me where is my error?

Reply | Quote

Replies

The table name is the middle argument, so try this:
DLookup(“City”,”Affiliates”,afid=1)

Reply | Quote

Hi,
The third argument also needs to be a string:
DLookup(“[City]”,”Affiliates”,”[afid] = 1″)
Hope that helps.

Reply | Quote