DLookup Function In Query

[DBFIN]

I want to use a dlookup function in a query that retrieves the value in an unbound textbox of a dialog box. In this example, I'm trying to retrieve the value entered in the unbound textbox called "Source" which is in a form called "Enter Source Code". I get an error message saying there is the wrong number of arguments.

RetrieveLookup( Forms![Enter Source Code]![Source] )

 

[KeithG]

The dlookup function will retrieve a value from a table. Just reference the form and control in a query field to use the value.

 

[DBFIN]

Thanks. Problem solved.