DLookup in a report doesn't work when put the report in a navigation form

Question

Hello everyone,

I am new to Access and I've attempted to use a DLookup as a control source in a report like this:

=DLookUp("txtVehicleName","tblVehicle","VehicleID=" & [Reports]![rptMountingPosition]![Vehicle_FKID])

It works well when I open the report direktly from the left navigation pane. But thing became weired when I creat a navigation form and put this report into it. It does not work any more, only shows a "#Name?" error message.

Is there anyone could give me a hand?

Thanks very much.

 

Answer 1

Does this work?

DLookUp("txtVehicleName","tblVehicle","VehicleID=" & [Vehicle_FKID])

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

OMGGGGGGGGGGGGGGG, You saved my day, it works. I've tried also other solutions in the meantime like this:

=DLookUp("txtVehicleName","tblVehicle","VehicleID= " & [Forms]![frmNavigation]![NavigationSubform]..[Form]![Vehicle_FKID])

But it didn't work out. It's unbeliveble that the answer is so simple....