mtagliaferri
Registered User.
- Local time
- Today, 02:15
- Joined
- Jul 16, 2006
- Messages
- 519
I have a form which opens a list of records from a query, all records are displayed, on the form I have some command buttons to filter these records as view All, Active or resigned
It all works fine, what I would like is that the initial list of records when the form is opened is only the active records (Or non Resigned); I have placed a false criteria in the query and indeed it filters all the correct records however the command button for viewing the resigned records does not work.
Is there a way as the form is opened to show only those active records without manipulating the query?
PHP:
Private Sub CmdViewActive_Click()
DoCmd.BrowseTo acForm, "frmCrewMemberList", "", "[Resigned] = False", "", 1
End Sub
Private Sub CmdViewAll_Click()
Dim strsearch As String
strsearch = "SELECT * from qryCrewMemberList"
Me.RecordSource = strsearch
End Sub
Private Sub CmdViewResigned_Click()
DoCmd.BrowseTo acForm, "frmCrewMemberList", "", "[Resigned] = True", "", 1
End Sub
Is there a way as the form is opened to show only those active records without manipulating the query?