Switchboard that change with time of the day

[yoshi88]

I want a switchboard that will change a 6:00 PM. I already have an hidden form (switchboard2), I want it to open at 6:00 PM and at the same time close the first switchboard. I am not really good with VB code, can someone help me.

If there is a better way than using 2 forms, let me know

 

[hennep]

you can do this in the timer event of the first form using this code:

if hour(time())=18 then
docmd.close acform, me.name
docmd.openform "switchboard2"
endif