Solved Open Form and filter results

[Snowflake68]

I have a piece of VBA code that opens a form and filters the results with a two column criteria, which works perfectly.

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

 

[Snowflake68]

Yah Ive just managed to do this myself

DoCmd.OpenForm "sfrm_Report_Detail", acFormDS, , "[Status]= '" & Me![Status] & "'  AND [Table]= '" & Me![Table] & "'AND [Type]= '" & Me![Type] & "'", , acDialog