I have a button that opens a form with the VBA below.This defines all approved "Sessions" or records. I also have a checkbox to denote whether the Session has been paid along with a date field that automatically fills the date upon click.

What I am trying to do is only show the records in this form that are not paid (checkbox=false) and show the same record group that has been checked paid in another form (checkbox=true). I have tried to ad an AND to the where clause, but, I am tripping over how to add this criteria to create my desired conditions in the two forms. I am sure I am missing something simple...


You guys are always awesome, thanks!

Private Sub Command49_Click()

    DoCmd.OpenForm "SuperuserSessionsApprovedF", , , "SessionStatus=""APPROVED"""
    DoCmd.Close acForm, "SuperUserMenu", acSaveYes

End Sub