open form based on system's date

[george]

How can I make a form, with a date field on it, open
programmatically when the system's date is equal to the
field's date? (assuming that my access application is
already open)
..

 

[Dan Artuso]

Hi George,
See my reply to your original post.

Dan Artuso, MVP

 

[Guest]

Dan,
thanks again for your reply. I already know all this, I
repeat I have a database already functioning. Can you give
me a clue regarding my question?

 

[Dan Artuso]

Okay, I'll repeat my reply here:

If your tblReminders has only one record, just use DLookup()

If DLookup("[RemindMeOn]","tblReminders") = Date() Then
DoCmd.OPenForm ........
End If

If you have more than one record in your table, you'll have to use the criteria argument
of DLookup to pick the entry you want to compare against.