DLookup Date

[gmazza via AccessMonster.com]

nope, same thing.

Hold on. VisitDate is a field in the form's underlying recordset, correct?
If it's also the name of the text box to which that field is bound, you may
need to rename the text box (say, to txtVisitDate), and use Me.txtVisitDate
in your lookup.

Same thing. Its really weird, I must be doing something wrong??

[quoted text clipped - 8 lines]

 

[Douglas J. Steele]

Sorry, I can't offer any other suggestion other than point out the fact that
your debug statement didn't return a value indicates that you're not
addressing the proper control (or you're not address the control properly).


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

nope, same thing.

Hold on. VisitDate is a field in the form's underlying recordset, correct?
If it's also the name of the text box to which that field is bound, you
may
need to rename the text box (say, to txtVisitDate), and use
Me.txtVisitDate
in your lookup.

Same thing. Its really weird, I must be doing something wrong??

[quoted text clipped - 8 lines]

I'll make you a citizen of the world yet, Dave! <g>

 

[AccessVandal via AccessMonster.com]

gmazza,

We don’t know what you did wrong.

Try creating a new temporary form with a control and bound the form’s record
source to the form. With the control, insert or key into the control source
where the Dlookup as what Doug had given to you but this time use the actual
date.

= DLookup("VisitDate", "PatientData", "VisitDate = #07-07-07#â€)

Replace the date to your actual date and make sure that your Regional Date
setting is as according to that Fomat.

Example, the #07-07-07# refers to #07-Jul-07# (dd-mmm-yy) if you are using
this format.

Post the result of the control’s value if the problem is still there, check
the table coulmn “VisitDate†format, make sure there’s nothing the the format
field in the General tab.