Want calling program not to continue until called form has been closed

[GeorgeJ]

I have a form F_SelectDeck whose function is to allow the user, by interacting with the form, to set the value of a global integer DeckSelected. By itself the form works properly. I was under the impression that if the form's modal property were set to yes, then after calling the form the code after the code which called the form would not execute until the form was closed. Evidently this is not the case.




I have the following code.
Sub SelectDeck()
DoCmd.OpenForm "F_SelectDeck"
End Sub

Sub Test09()
SelectDeck
MsgBox "The Deck selected was " & SelectedDeck
End Sub

When I run Test09 I immediately get the message "The Deck selected was " followed by the original value of SelectedDeck, which is not what I want. What I want is for program execution to not continue until F_SelectDeck has been exited. The modal property of F_SelectDeck is set to yes.

How might I get the program to operate as I want it to?

Thanks in advance.

[GeorgeJ]

AHAH!!!

I just found the answer by using the searchbox on this forum and typing in "modal form" and then looking at the various posts until I came to one that showed the same issue as mine.

Our esteemed "Wino Moderator" answered the same question almost 5 years ago. I'd put the link here but I haven't figured out how to do that yet.


Paul suggested setting acDialog as the acWindowMode parameter in the Docmd.openform command. I wasn't sure what that meant, but I used the help file in Access VB and searched "Openform" and clicked on a promising reference and found that acWindowMode is the sixth parameter in the openform command. I then clicked on the acWindowMode and found several options, on of which was acDialog, which sets the forms modal and popup properties to yes. So my code works perfectly if I replace

DoCmd.OpenForm "F_SelectDeck"

with

DoCmd.OpenForm "F_SelectDeck", , , , , acDialog


Thanks Paul

[ranman256]

You could do
DoCmd.OpenForm "f_SelectDeck", acNormal, , , , acDialog

your global assignment must be done in a PUBLIC module and assigned before form exit

[ssanfu]

Great job researching..

And thanks for posting your solution... I'm sure it will help someone else.


Ready to mark this solved?