troubleshooting Question
Make a Subform Field Required
I Have a form that is in a tab format.
One of the tab pages is a subform. On save I have some fields that are required before it will save. I need it to also make fields required on the subform but the code is not working.
Any experts know what im doing wrong? here is the code:
(frmInductionChecks) is the name of the subform.
(frmMain)is the name of the main form.
(Date of Induction) is the name of the control.
If IsNull(Me!frmInductionChec
MsgBox "You must provide a value for Perform Date of Induction."
Me.Me!frmInductionChecks.F
Cancel = True
Exit Sub
End If
If IsNull(Me.Text562) Then
MsgBox "You must provide a value for Perform Fire Turret Runout Reading."
Me.Text562.SetFocus
Cancel = True
Exit Sub
End If
One of the tab pages is a subform. On save I have some fields that are required before it will save. I need it to also make fields required on the subform but the code is not working.
Any experts know what im doing wrong? here is the code:
(frmInductionChecks) is the name of the subform.
(frmMain)is the name of the main form.
(Date of Induction) is the name of the control.
If IsNull(Me!frmInductionChec
MsgBox "You must provide a value for Perform Date of Induction."
Me.Me!frmInductionChecks.F
Cancel = True
Exit Sub
End If
If IsNull(Me.Text562) Then
MsgBox "You must provide a value for Perform Fire Turret Runout Reading."
Me.Text562.SetFocus
Cancel = True
Exit Sub
End If
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 10 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.