open 1 form, then a second

[Mark J Kubicki]

I want to open a first form: "frmFixtureSchedulePrintOptions"
then after, and not until, that form has closed, open a second form:
"FixtureSchedule"

"frmFixtureSchedulePrintOptions" is modal, so I thought that it would delay
opening the second until it had been closed (this seems not to be the case)

the (partial) code behind a form's command button is:

stDocName = "frmFixtureSchedulePrintOptions"
DoCmd.OpenForm stDocName, acNormal

stDocName = "FixtureSchedule"
DoCmd.OpenReport stDocName, acPreview

thanks in advance,
mark

 

[Allen Browne]

The code is not opening the form modally.

Try:
DoCmd.OpenForm stDocName, WindowMode:=acDialog

 

[mark kubicki]

THAT DID IT... thanks

The code is not opening the form modally.

Try:
DoCmd.OpenForm stDocName, WindowMode:=acDialog