Multiple Where Condition Filters (Open Form Macro)

[EdMasto]

I am trying to set multiple where condition filters on Open Form Macro.
CustNumber = CustNo And OpenQty >= .01

The field OpenQty is on the Form to be opened

I currently have this in the where condition

="[CustNumber]=" & "'" & [CustNo] & "'" And [OpenQty]>=0.01

Any Help would be greatly appreciated!

 

[pbaldy]

Try

="[CustNumber]='" & [CustNo] & "' And [OpenQty]>=0.01"

 

[EdMasto]

That Worked AWESOME. I get very confused by the quotes and single quotes sometimes.

Thanks for the help. I am very new to Access but love it. Hope MS doesn't discontinue this software!

 

[pbaldy]

Happy to help! They still have a development team, so I don't think it's going away anytime soon.