Brian Martin
Registered User.
- Local time
- Today, 04:10
- 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?
=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?