I am having a problem setting the criteria part of the DLookup method
correctly and am consequently getting an error message.
I have a database of staff duties, part of which is a query (qryDaily)
that returns all staffs duties for a selected day.e.g.
Fullname Duty
Name1 E1
Name2 Sick
Name3 Pwk N2
Name4 N4
Name5 Pwk D1
etc
I would like to produce a daily report and have various textboxes that
use the DLookup function to return the name of the person on specific
duties.
To that end I have set up a text box with the Control Source as
=DLookUp("Fullname","qryDaily","[Duty]=E1") hoping that it would return
the result Name1 (for the example data above) but all I get is an error
message. I have tried various ways of arranging the criteria part of
this method but without success. Could somebody point me in the right
direction as regards the correct wording for the criteria please?
Many thanks
Chris Thompson.