Messages pop up one after other ?

[jj1]

My problem is I am using this code and MsgBox show up one after other however I want it show first popup for name and then person fills that info and next popup I don't know what I am missing in the code. Please help. I have a form on which people fill half info and scroll forward and open a new record so I am trying to block them doing so.


Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim YourName As String
Dim cboCenter As String




If IsNull(Me.[YourName]) Then
Cancel = True
MsgBox "You must provide Name"
If (Me.[YourName]) <> "" Then
Exit Sub
End If
End If


If IsNull(Me.[cboCenter]) Then
Cancel = True
MsgBox "You must provide Center"
If (Me.[cboCenter]) <> "" Then
Exit Sub
End If
End If

End Sub

[amrut]

Do not use similar variables and controlnames See this for more http://access.mvps.org/access/general/gen0012.htm
Try this -

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim UserName As String
Dim cboCenterName As String

 
If IsNull(Me.[YourName]) Then
MsgBox "You must provide Name"
Cancel = True
Exit Sub
End If



If IsNull(Me.[cboCenter]) Then
MsgBox "You must provide Center"
Cancel = True
Exit Sub
End If

 
End Sub

[June7]

Aside from an InputBox or opening another form in acDialog mode, I don't know any way to pause code execution after MsgBox to allow user input before next MsgBox popup.