Change me.sourceobject

[Peter D]

in access 97
on form open i have :

Me!frmContent.SourceObject = "frmabout"
Me!frmmenustart.SourceObject = "frmmenuaanmelden"
'"frmmainmenulist"

where frmcontent and frmmenustart are two subforms on a frmmain (main
form)

But i would like

Me!frmContent.SourceObject = "frmabout"
Me!frmmenustart.SourceObject = "frmmenuaanmelden"
'"frmmainmenulist"

(and after about 3 seconds)

Me!frmContent.SourceObject = "frmstartwork"

i tried it with a loop that holds up the frmworkstart and the doevents
between the code but it's no go.

Is there a solution or am i looking the wrong way?

Tx anyone, anywhere, anytime, anyhow

[Rog]

Why not make frmAbout a separate form? You could build in a loop and
close it when the loop is done.

[Bob Quintal]

da*********@pandora.be (Peter D) wrote in
news:2f**************************@posting.google.c om:

in access 97
on form open i have :

Me!frmContent.SourceObject = "frmabout"
Me!frmmenustart.SourceObject = "frmmenuaanmelden"
'"frmmainmenulist"

where frmcontent and frmmenustart are two subforms on a
frmmain (main form)

But i would like

Me!frmContent.SourceObject = "frmabout"
Me!frmmenustart.SourceObject = "frmmenuaanmelden"
'"frmmainmenulist"

(and after about 3 seconds)

Me!frmContent.SourceObject = "frmstartwork"

i tried it with a loop that holds up the frmworkstart and the
doevents between the code but it's no go.

Is there a solution or am i looking the wrong way?

Tx anyone, anywhere, anytime, anyhow

Use the timer event of the form. In design mode set the timer
value to 3000 (milliseconds)
In the On Timer event set that value to 0, which turns off the
timer, then set your new subform, You may need to do a me.refresh
to see the update.

--
Bob Quintal

PA is y I've altered my email address.