I have a text box on a form that looks up the number of vehicles in another table. there is only one value in the table.
Number of Vehicles is the column name
NumberOfVehicles is the table name
Text66 is the textbox name
the textbox returns #Name?
What's causing the problem?
Code:
=DLookUp("Number of Vehicles","NumberOfVehicles","[Number of Vehicles]=" & [Me]![Text66])
Number of Vehicles is the column name
NumberOfVehicles is the table name
Text66 is the textbox name
the textbox returns #Name?
What's causing the problem?