Filter a form based on two fields from click of button

norrisr4

New Member

Join Date: Feb 2016

Posts: 1
#1

Filter a form based on two fields from click of button

Feb 18 '16, 03:58 PM

I can get this to work...
Me.[ScratchPadList subform].Form.Filter = "[Stage] = 4"

and I can get this to work
Me.[ScratchPadList subform].Form.Filter = "[Ready for Gate] = Yes"

How do I apply them together as one using AND ?
Tags: None
Luk3r

Contributor

Join Date: Jan 2014

Posts: 300
#2

Feb 18 '16, 04:06 PM

Code:

Me.[ScratchPadList subform].Form.Filter = "[Stage] = 4 AND [Ready for Gate] = Yes"
Comment

Comment