I want to hold off on running some code until after I finish working with the called form.
The following works:
DoCmd.OpenForm "NextForm", , , , , acDialog
' This code runs when the Nextform is finished.
The following does not work"
DoCmd.OpenForm "NextForm", acFormDS,,,,acDialog
' The code immediately runs instead of waiting for
NextForm to finish being use!
How do I postpone the code since acDialog obviously does not work with a Datasheet view??? I tried setting a memvar like mContinue to false then resetting it to True in the NextForm close event. Still doesn't work. Please give me some ideas that can work.
Steve
The following works:
DoCmd.OpenForm "NextForm", , , , , acDialog
' This code runs when the Nextform is finished.
The following does not work"
DoCmd.OpenForm "NextForm", acFormDS,,,,acDialog
' The code immediately runs instead of waiting for
NextForm to finish being use!
How do I postpone the code since acDialog obviously does not work with a Datasheet view??? I tried setting a memvar like mContinue to false then resetting it to True in the NextForm close event. Still doesn't work. Please give me some ideas that can work.
Steve