DLookup

[Brian Martin]

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]

Try this

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