continuous sub form with independant checkboxs

[kccced]

I have a form with a check box and a sub form that loads with the on load event when the sub form loads it checks to see if there is any records unchecked and returns the unchecked records but the sub form shows all records (How do I get just the unchecked to show ??)

Email address removed per forum rules

[Stewart Ross]

Without much more information from you (for example listing the fields in your tables and their relationships) it is hard to advise you.

Generally, you could either base your subform on a query in which you have a WHERE clause restricting the records to those where the field representing your checkbox has a value of TRUE, or you can apply a filter to the subform's recordsource to the same effect as part of the On Load event processing.

Give us a bit more detail about the relationships and fields involved and I'm sure we can be of more assistance in our replies.

Welcome to Bytes!

-Stewart

[kccced]

(This is my code for the on load event for the switch board)

Private Sub Form_Load()
 
'On Load of the switchboard check Date table for any overdue Dates
 
Dim intStore As Integer
 
'Count of PM Schedule that are past the Expected DueDate
intStore = DCount("[DueDate]", "[qrytblDate]", "[DueDate] <=Now() AND [Complete] =0")
 
'If count of uncomplete jobs is zero display switchboard
'Else display message box detailing amount of jobs
'and give the user the option as to whether to view these or not.
    If intStore = 0 Then
            Exit Sub
                Else
                    If MsgBox("There are " & intStore & " Inspections Due " & _
                    vbCrLf & vbCrLf & "Would you like to see these now?", _
                    vbYesNo, "You Have Inspections Due...") = vbYes Then
                    DoCmd.Minimize
                    DoCmd.OpenForm "frmReminders", acNormal
                Else
            Exit Sub
        End If
    End If
End Sub

(this is my sub form fields)


status, actual finish, workorder#, tech ID, complete (the complete field is the check box)

[NeoPa]

I think you need to understand that unbound controls in continuous forms do not persist (Why Values in Unbound Form Controls do not Persist).

If your problem is something else, then for goodness sake tell us what your problem is. We're not mind-readers, nor do we want to spend ten minutes trying to guess what you mean, so that you don't have to take 5 asking your question properly.