Snowflake68
Registered User.
- Local time
- Today, 04:43
- Joined
- May 28, 2014
- Messages
- 452
I have a piece of VBA code that opens a form and filters the results with a two column criteria, which works perfectly.
However I need to add a third filter criteria (to the WHERE condition) for [Type] but I cannot seem to get the syntax correct with the AND and quotes in the correct place.
Thanks
Caroline
Code:
DoCmd.OpenForm "sfrm_Report_Detail", acFormDS, , "[Status]= '" & Me![Status] & "' AND [Table]= '" & Me![Table] & "'", , acDialog
However I need to add a third filter criteria (to the WHERE condition) for [Type] but I cannot seem to get the syntax correct with the AND and quotes in the correct place.
Thanks
Caroline