Hello- I have several subforms within one form. Each subform has code in it that alerts the user that he/she did not fill in a required field - example follows:
If IsNull(Me.X) = True Then
MsgBox "Click on Intensity level."
Me.y.SetFocus
Me.x.SetFocus
End If
The problem here is...
I am creating a data entry form with required fields. I have set data entry code in the "On Exit" as follows:
Private Sub responsible_Exit(Cancel As Integer)
If IsNull(Me.responsible) = True Then
MsgBox "Click on Responsible level."
Me.responsible.SetFocus
End If
End Sub
The problem...
I am setting up a data entry form that has required fields; the form has 7 subforms and I am having problems creating a "back button" to go (for example) from subfrom 7 to subform while staying in the same record.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.