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.
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.