D
Drew
IF you have the user sign in, it is a piece of cake, as
long as you save the users ID with the reminder. When
the user logs in, have the login screen run a "Open
Select * from table WHERE user_id = ... AND ReminderDate
= Now()
Then test if the .recordset > 0 and if it is launch the
form ... Docmd.OpenForm "formname".... showing the data
you want by having the form either bound by the table and
send it a Filter to only show the users records, or have
an unbound form filled through code by inserting the data
from the above recordset into the various related fields.
Drew
(Sorry for such a late posting... busy today on my own
nightmares!)
long as you save the users ID with the reminder. When
the user logs in, have the login screen run a "Open
Select * from table WHERE user_id = ... AND ReminderDate
= Now()
Then test if the .recordset > 0 and if it is launch the
form ... Docmd.OpenForm "formname".... showing the data
you want by having the form either bound by the table and
send it a Filter to only show the users records, or have
an unbound form filled through code by inserting the data
from the above recordset into the various related fields.
Drew
(Sorry for such a late posting... busy today on my own
nightmares!)