Button to check for missing values in a MainForm and Subforms in MS Access

Viewed 24

New to Access (still), have only basic VBA skills.

I've got 3 subforms (subfrm_PackingSteps1 , subfrm_MetalDetection and subfrm_Weights - the first 2 are continuous and the other one is single form) within a main form (frm_daily_packing_record) that users go through and input data. The user should be able to input data in no particular order, and only at the end there would be a button to confirm that the user is ready to save this form.

I'd like to have this button on the main form that checks each control (in main form and subforms) for empty values. I found and adjusted a code to check the recordset of one of the continuous forms (see below), but I can't figure out:

  1. how to include a code that checks each control instead of manually adding all of them (I've used a function before that utilises the Tag property, but can't add it to this)

  2. how to keep the button in the main form while checking the controls/recordsets in the other subforms.

Thanks in advance.

Private Sub ConfirmBtn_Click()
Dim blnSuccess As Boolean
 
blnSuccess = True
 
Me.Recordset.MoveFirst
Do While Not Me.Recordset.EOF


 If IsNull(Me.pc) Or IsNull(Me.InnerP) Then
   blnSuccess = False
        
        Exit Do
    End If
    Me.Recordset.MoveNext
Loop
 
If blnSuccess = True Then
    MsgBox "You may proceed to save this record"
Else
    MsgBox "You still have some empty fields to fill in!", vbCritical + vbOKOnly, "Empty Fields!"
End If
End Sub
0 Answers
Related