Modal Form

[ManuPR]

I want to open a form, change some properties and disable some controls
depending on the situation and then wait until the form is closed to return a
value. If I use DoCmd.OpenForm ,,,acDialog the code stops and I'm not able to
change anything on the form until it is closed. If I don't use the acDialog
option, the code continues to run without waiting for the value to be
returned.
Is there a way to open a form, run some code against it and then make it a
dialog so the code waits for it to be closed?

 

[Douglas J. Steele]

Can you put the logic to change the properties in the Load event of the form
you're opening, rather than trying to control it from the original form? You
can always pass it information using the OpenArgs property to tell the Load
event what it's supposed to be doing.

 

[ManuPR]

Thanks Douglas, that is exactly what I did and it worked fine.