DLookUp runtime 2471

[BadgerLikeSpeed]

The saga of my access attempts continues... I'm trying to get information from another table WatEngDataWeek, in the field WkEnd and fill it in to a text box on a form called TestEngDataNew

WkEnding = DateAdd("d", -1, [Forms]![TestEngDataNew]![WkSt])
MsgBox (WkEnding)
lookup = DLookup("[WatEngDataWeek]![GOEnd]", "[WatEngDataWeek]", "[WatEngDataWeek]![WkEnd] = WkEnding")

Gives me a run time error 2471, with error 'WkEnding'. The message box was just put in to make sure that the date was being calculated correctly, and it is. There is an entry in the table WatEngDataWeek, in the field WkEnd of the correct date.
Where am I going wrong? I've tried google, but have not been able to solve my problem...

 

[Solo712]

The saga of my access attempts continues... I'm trying to get information from another table WatEngDataWeek, in the field WkEnd and fill it in to a text box on a form called TestEngDataNew

WkEnding = DateAdd("d", -1, [Forms]![TestEngDataNew]![WkSt])
MsgBox (WkEnding)
lookup = DLookup("[WatEngDataWeek]![GOEnd]", "[WatEngDataWeek]", "[WatEngDataWeek]![WkEnd] = WkEnding")

Gives me a run time error 2471, with error 'WkEnding'. The message box was just put in to make sure that the date was being calculated correctly, and it is. There is an entry in the table WatEngDataWeek, in the field WkEnd of the correct date.
Where am I going wrong? I've tried google, but have not been able to solve my problem...

Try:

lookup = DLookup("GOEnd", "WatEngDataWeek",  "WkEnd = #" & WkEnding & "#")

Best,
Jiri