Set a form to automatically open

[jlindquist23]

My database usually stays open all day. Inspection_Frm


At 7:00 AM, M-F, I'd like a form to open for the operator to perform tasks on the form (DailyMaintenance).
What is the best way to accomplish this?
Thanks for your help!

[ranman256]

In the inspection form ,turn on the timer interval property,
set the interval to 5000. (5 seconds)
in the ON TIMER event, check the time:

sub Form_Timer()
Dim vTime as date
vTime = time()

if vTime = #07:00 am# then docmd.openform "fDailyMaintenance"
end sub

[jlindquist23]

Wow! That works!
Thank you!!

[jlindquist23]

What code is required to open it to a new record?