OK...please someone help
I am using a record source select query for a subform. I want the subform to have filters based on several option button on the main form.
To accomplish this I thought I could use an if statement under each field that can be filtered, below is the working if statement:
IIf([Forms]![MainForm]![OptionFilter]=True,-1,0)
problem is if the filter is false I want all data to displayed not just the false data, but if I use:
IIf([Forms]![MainForm]![OptionFilter]=True,-1,0 OR -1)
no go...