DLLOKUP dtpicker

[shamas21]

Hi

I cant get the Dlookup to work.

=DLookUp("notes","tblcalendar","Date=" & [dtpicker1])

if i change to the following then it works

=DLookUp("notes","tblcalendar","Date= #01/01/2008#")

How can i get it to lookup the dtpicker1 to work?

Thanks

 

[boblarson]

=DLookUp("notes","tblcalendar","[Date]=[color=red]#[/color]" & [dtpicker1] & [color=red]"#"[/color])

 

[boblarson]

Now, one more thing - You should NOT be using DATE for a field name. That is an Access Reserved Word and you do not want to name fields or objects those. I would change it ASAP as it can only cause you pain if you don't.