Multiple filters on Form Open

MonkeyChico

Registered User.
Local time
Today, 05:14
Joined
May 11, 2010
Messages
18
I have a command button that opens a new form and filters that form for the ID of the previous form:

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_QAList"

stLinkCriteria = "[Quote_BookID]=" & Me![Quote_BookID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

What would I add to the code to filter a field [QA Flag] on the new form (frm_QAList) when it equals "Yes". i.e. filter [QA Flag] = "Yes".

I've been searching for hours and can't find the answer. Thank you in advance.
 
stLinkCriteria = "[Quote_BookID]=" & Me![Quote_BookID] & " AND [QA Flag] = True & """

Asuming that QA Flag is a boolean field
 
Thanks very much David, that did the trick.
 

Users who are viewing this thread

Back
Top Bottom