The code does not stop when the pop up form opens. I don't get to make a choice until all the code stops running.
The pop up form is called puHowToBill. The code behind the form is:
Private Sub popupHowToBill_Click()
pubLngGen = popupHowToBill ' name of option group holding option buttons
Debug.Print "pubLngGen " & pubLngGen
DoCmd.Close
End Sub
Then I have a button (on a separate form) to open the pop up form:
Private Sub btnOpenPopUp_Click()
DoCmd.OpenForm "puHowToBill"
Select Case pubLngGen
Case 1
MsgBox "You have chosen 'Regular Mail'"
Case 2
MsgBox "You have chosen 'Email'"
Case 3
MsgBox "You have chosen '3rd Party'"
Case 4
MsgBox "You selected to skip setup"
End Select
End Sub
On the pop up form (which I will try to attach) Pop Up is set to YES and Moday is set as YES.
How can I make it stop for input?