AccessAmateur
Registered User.
- Local time
- Yesterday, 21:19
- Joined
- Feb 13, 2003
- Messages
- 30
Ignore last post. I hit the wrong key & it posted before I was finished.
I have two forms. How do I do the following?:
Sub: Event dbl click
Open the 2nd form
Transfer control to the 2nd form so that the user can select a record WITHOUT finishing this routine. ie suspend execution of this routine until the user selects a record in the 2nd form & returns.
On returning control to here, resume execution of this code.
End Sub
This doesn't work although you would think it should:
(yes I know the syntax is wrong)
Sub dblclick
MsgBox "I am here now"
Open Form2
DoCmd.GotoControl Field1 in 2nd form.
MsgBox " I shouldn't get here until control is returned"
MsgBox "but I do"
EndSub
The whole code will execute BEFORE transferring control to the 2nd form.
I have two forms. How do I do the following?:
Sub: Event dbl click
Open the 2nd form
Transfer control to the 2nd form so that the user can select a record WITHOUT finishing this routine. ie suspend execution of this routine until the user selects a record in the 2nd form & returns.
On returning control to here, resume execution of this code.
End Sub
This doesn't work although you would think it should:
(yes I know the syntax is wrong)
Sub dblclick
MsgBox "I am here now"
Open Form2
DoCmd.GotoControl Field1 in 2nd form.
MsgBox " I shouldn't get here until control is returned"
MsgBox "but I do"
EndSub
The whole code will execute BEFORE transferring control to the 2nd form.