How do I halt/suspend execution of statements immediately following a DoCmd.OpenForm "MyForm" until the form "MyForm" closes? I.e., when form "MyForm" issues the command DoCmd.Close.
How do I halt/suspend execution of statements immediately following a DoCmd.OpenForm "MyForm" until the form "MyForm" closes? I.e., when form "MyForm" issues the command DoCmd.Close.
IIRC, you might try setting the form "MyForm" modal property to Yes.
Edit: found these:
http://www.kallal.ca/Dialog/Index.html
http://www.utteraccess.com/forum/Mod...-t1960338.html
Try acDialog, works for me.
DoCmd.OpenForm "MyFormName", , , , , acDialog
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks June, that did it for me too.
Bill