Dlookup Error doing my head in

[CSP12345]

Hi all,
I suspect this ha been covered but I have tried everything and searched every were please help

Ok I have created a query "query1"
In query1 I have a field "Assest Number" "BatteryType" that is just pulling information direct from a table "3 Yearly Cost"
and in another field "BatteryCost" that I want to look up the cost of the battery from a table "BatteryTb" field "BatteryCost1"

My Expression is this BatteryCost: DLookUp("BatteryCost1","BatteryTb","Batterytype1 =" & [BatteryType])

The Error it is returning is The object doesnt contain the automation object "GP1272"
GP1272 is a battery type that is displaying in the query filed "BatteryType"


Any help please, Im good with Excel but new to Access and the cross over is doing my head in

 

[CSP12345]

No it's in the Field Properties of the field, the Query Properties are, for welll the query.

No worries mate, once again thank you for your help I may need to ask you more soon.