Modal form not working

[mackyrm]

In Access 2010, I have a form with VBA. Within that VBA I have a modal form. However, when that form is referenced:

DoCmd.OpenForm ("frmEmailModal")

The form loads and the code it is referenced from continues, without waiting for the form to close. I have checked that the modal property = yes.

At the moment, I don't have code in the form, just variables accessing the text boxes for passing to global variables.

Any advice appreciated.

 

[CJ_London]

This link tells you about modal forms


http://msdn.microsoft.com/en-us/library/office/ff821033(v=office.15).aspx

I think you will find you need to include additional parameters in your docmd.openform