Suspendig code after form opens

[Mat Child]

Hi,
I know that opening a form as acdialog suspends the calling code, however i
don't want the code suspending at the point of opening, but a few statements
later. This is because the calling code amends the form based of conditions.
If acdialog is used the amendments are not made.
It is not possible for code in the open form to make those amendments
because the conditions are only in the calling code.

I've tried

DoCmd.OpenForm "formname", , , , , acHidden
[statements to modify here]
DoCmd.OpenForm "formname", , , , , acdialog
[rest of code]

but the code doesn't halt after the 2nd openform command.

Is there any way round this at all?

regards

Mat

 

[Mat Child]

Oh, hang on - i think the open args property might be what i need
I'll start looking into that

 

[Mark VII]

I think you're on the way to what you need. I routinely check the OpenArgs
property in the Form Open event, and take action from there.

Mark