MachineBoy
Programmer
How would I pass input from the user entered into a text box as part of a parameter query in a DLookup statement
ex -
code
If IsNull(DLookup("[Project]", "Query5Act", "[Project] = 'strText'") Then
/ code
where Project is a field in a table and strText would be the particular Project that the user entered into a text box as part of the parameter query ("Query5Act"?
ex -
code
If IsNull(DLookup("[Project]", "Query5Act", "[Project] = 'strText'") Then
/ code
where Project is a field in a table and strText would be the particular Project that the user entered into a text box as part of the parameter query ("Query5Act"?