DLookup (1 Viewer)

Brian Martin

Registered User.
Local time
Today, 22:55
Joined
Jul 24, 2002
Messages
68
I'm the following function in the control source of a textbox on my report:

=DLookUp("Specs","tblAssys","ListID = [Forms]![CurrentList]![ListID]")

I am trying to display Specs from table tblAssys where tblAssys. listID = the value of ListID text box on the CurrentList form.

I'm getting an error displayed. What am I doing wrong?
 

Robert Dunstan

Mr Data
Local time
Today, 22:55
Joined
Jun 22, 2000
Messages
291
Try this

=DLookUp("[Specs]","tblAssys","[ListID] = [Forms]![CurrentList]![ListID]")
 

Users who are viewing this thread

Top Bottom