Refering To Another Table Field

[dbmanalser84]

I have a form in which I need to calculate total price for the selling car. I'm ccalculating by this formula Total=intCarCost+[inCarCost*(intTaxRate)/100]. My intCarCost and intTaxRate are fields from other two tables, tblCars and tblTaxex.
How do I reffer to those fields, I tried various combinations, and instead of value 18 for intTaxRate I'm getting #Name? value.

 

[KeithG]

Are the fields included in the recordsource? If not you need to use the dlookup funciton.