Using Access 2010 on Windows Vista
I have a report called InventoryCard, A Table, NewMotorInventory, and a lookup table, Horsepowers. The Report's RecordSource is NewMotorInventory. I placed a textbox, tbHorsePower, on the report with ControlSource
=DLookUp(" [Horsepowers]![HorsePower]",
"[Horsepowers]","[NewMotorInventory].[HorsePower] = [Horsepowers].[HorsepowerID]")
This returns #Error in tbHorsePower.
However if I place another textbox, tbHP, on the report and set its ControlSource to HorsePower, tbHorsepower now shows the correct value from the Horsepowers table.
Can anyone explain why this is happening this way. To me it seems that neither of these two text boxes should have any effect on eachother.