Thanks. That works, however, it's very slow. I think that is why you recommend checking the record on the form. That was my original design, which looked something like this:
Code:
Private Sub Command46_Click()
Dim ctrl As Control
For Each ctrl In Me.Section(acDetail).Controls
Select Case ctrl.ControlType
Case acTextBox, acComboBox
If IsNull(ctrl.Value) Then
Me.chkValid = False
Exit Sub
End If
End Select
Next
Me.chkValid = True
End Sub
The problem I had with this is that it only checks the record that is selected. To give some additional context on what I'm doing, I have a combobox (cboFltrValid) that I manually assigned row source as follows:
-1;"Valid";0;"Non-Valid";1;"All"
When id -1 is selected, the afterupdate event will trigger the form to filter all records with a checkmark (chkValid), if id 0 is selected the form will filter all records with no checkmark, if id 1 is selected, the form will filter both checkmarks and non-checkmarks. While that is fairly easy to do, the trick is updating the table such that any record with a null field will not have a checkmark, when the user selects whatever option. Simply put, If any field in a record is null then chkValid is false else chkValid is true.