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...
This database is replicating one that was written 6 years ago for probation officers. The problem is that we don't have the original source code available (the programmer used an Access database but the data entry, etc. are in a different program) and weren't able to update from Access '97 to...
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.