Waiting a Form to Close before executing the next statement

[raabbasi]

I am trying to use a Modal Form inside a procedure for collecting some user-specific information (say, Username/password, for example).

I expect it to function in a way that unless a user clicks 'OK' or 'Cancel' button (that is unless that form gets closed), the execution should not pass on to the statement next to the one which is calling that Modal form.

The Modal form appears as expected, but the statement(s) following the call to this form are also executed without waiting for that form to close.

Suggestion for the logic to achieve the purpose is requested for anticipated thanks.

 

[KenReay]

Hi

See help on DoCmd.OpenForm, one of the parameters is Window style, you need acDialog

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[raabbasi]

Thanks KenReay.