Zydeceltico
Registered User.
- Local time
- Yesterday, 22:38
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
Attached is my db, It opens to the form in question.
That form has three combo boxes that cannot be null when one of the buttons in the lower left of the form are clicked.
Currently, if you don't select a Job and then click "Mill Inspection" you'll get a msgbx telling you that you need to make a selection. That is in the On_Click event of that button. The code is:
I have two issues:
1) I need the other two combo boxes to be checked for Null also and with a msgbx reminder for both of them if either or both are Null;
2) I wonder if I should put the checking code on the Main form instead of the button because I would have to put it on every button if I go that route.
Thanks for your help!
Tim
Attached is my db, It opens to the form in question.
That form has three combo boxes that cannot be null when one of the buttons in the lower left of the form are clicked.
Currently, if you don't select a Job and then click "Mill Inspection" you'll get a msgbx telling you that you need to make a selection. That is in the On_Click event of that button. The code is:
Code:
Private Sub cmdOpenMillInspection_Click()
Me.Dirty = False
If Not IsNull(Me.InspectionEvent_PK) Then
DoCmd.OpenForm "frmInspectMill", , , , , acDialog, Me.InspectionEvent_PK
'Me.Requery
Else
MsgBox "No Job Chosen. Parent Record Not Saved"
End If
End Sub
I have two issues:
1) I need the other two combo boxes to be checked for Null also and with a msgbx reminder for both of them if either or both are Null;
2) I wonder if I should put the checking code on the Main form instead of the button because I would have to put it on every button if I go that route.
Thanks for your help!
Tim