Solved Open Form and filter results (1 Viewer)

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.

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
 

Snowflake68

Registered User.
Local time
Today, 04:43
Joined
May 28, 2014
Messages
452
Yah Ive just managed to do this myself :)

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

Users who are viewing this thread

Top Bottom