open a form based on the system's 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)
 
D

Dan Artuso

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
 
G

george

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
 
D

Dan Artuso

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top