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!
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...