Dlookup Error - #Error

[primagic]

I have the following code in the control source however I am getting the #Error.

=DLookUp("[MileageRate]","tblVehicles","[RegistrationNumber] = " & [Forms]![frmCalculator]![txtRegNumber])

RegistrationNumber in tblVehicles is a text field.

The field on the form is a simple textbox

 

[PHV]

Try either this:

=DLookUp("[MileageRate]","tblVehicles","[RegistrationNumber]='" & [Forms]![frmCalculator]![txtRegNumber] & "'")

or this:

=DLookUp("[MileageRate]","tblVehicles","[RegistrationNumber]=[Forms]![frmCalculator]![txtRegNumber]")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886