Load and Unload a form

[MrMajik]

Does this work in Access or only in VB?

Load frmClock
frmClock.Show

 

[addy]

Never seen that used in Access before, I ususally use DoCmd.OpenForm "frmYourFormName

 

[fldbryan]

What are you trying to accomplish?

 

[MrMajik]

fldbryan, I have a clock and calendar form that opens and populates fields on the Main form. However, the code in the Main form continues to run past the DoCmd statement while the Calendar and/or Clock form opens.

I am trying to get the code to stop as soon as the Clock and/or Calendar form opens and then have the Main code continue after the Calendar and/or Clock form is closed.

Thank you,

MrMajik

There are 10 types of people in the world:
Those that understand binary and those that don't.

 

[jkl0]

DoCmd.OpenForm YourForm, , , , , acDialog

This will cause the code to wait until Clock/Calendar form closes to resume execution of code.

 

[PHV]

Does this work in Access or only in VB?
Load frmClock
frmClock.Show
this work in Access, provided frmClock is a UserForm instead of an AccessForm.

 

[MrMajik]

PHV, I believe the form is an AccessForm. I will convert it to a UserForm when I return to work this week. Will post how it went.

Thank you,

MrMajik

There are 10 types of people in the world:
Those that understand binary and those that don't.