open a form based on the 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)
 
Hi,
A form does not store data. The data is stored in tables.
Most tables have more than one record, so which record has to match
the current date?

HTH
Dan Artuso, MVP
 
Hi Dan,

All this is implied, I already have a functional dabase
with tables and queries. I just went to the end of the
situation to simplify the problem. Let's say I have a
table tblReminders with a date field RemindMeOn. If my
form is based on this table, how can I open it
programmatically based on the system's date? Thanks
 
Hi,
If your tblReminders has only one record, just use DLookup()

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

HTH
Dan Artuso, MVP
 
Back
Top