open form based on system's date

  • Thread starter Thread starter george
  • Start date Start date
G

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,
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?
 
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.
 
Back
Top