[AccessD] Dlookup syntax

I can't remember how to format this! Bloddy L. The second thing to go is
memory. I forget what the first is.

Dim s as string
Dim x as Integer
Dim d as Date

d = Date()
X = Dlookup("myColumn", "myTable", "myDateColumn=#" & d & "#")

Doesn't seem to work. What should I be doing instead?

TIA,
Arthur