I'm trying to check for null values on the main form and subform, but the subform null is not working. The subform control I want to ensure is not empty is txtDocInfo. "Me.tblTaskQuickSubform.Form.txtDocInfo".
I know that there should be an "!" vs the ".", but I'm sure there is something else wrong here. Can someone tell me know I'm doing wrong here.
Private Sub cmdSaveAndClose_Click()
If Len(Me.cboQuickTitle & vbNullString) = 0 Or _
Len(Me.cboOriginator & vbNullString) = 0 Or _
Len(Me.cboClientNumber & vbNullString) = 0 Or _
Len(Me.cboMatterNumber & vbNullString) = 0 Or _
Len(Me.tblTaskQuickSubform.Form.txtDocInfo) Then
MsgBox "Fill in everything."
Else
DoCmd.Close , ""
End If
End Sub