Dlookup using dates

[Jim Pockmire]

How would I construct a Dlookup statement to locate a specific date in a
table based on a date on a form?

 

[Damian S]

Hi Jim,

Something like this:

dlookup("DATEFIELD", "TABLENAME", "[DATEFIELD] = #" & format(me.DATEONFORM,
"yyyy/mm/dd") & "#")

Hope this helps.

Damian.