Rocky Smolin
rockysmolin at bchacc.com
Sun Sep 25 20:14:27 CDT 2011
Dear List:
I'm trying to set the filter of a subform from parameters on the main form.
The first line is
Me.subfrmAccountsReceivable.Form.Filter = ""
But it wasn't working - so I put:
MsgBox Me.subfrmAccountsReceivable.Form.Filter
right after the first line and it prints "False"
After that first line there's code which I've written a dozen times to
accumulate the filtering criteria (in this case an account number and a >=
and <= date range) but always for the parent form - never for a sub form.
What am I doing wrong? (Besides not drinking some Scotch and making dinner
at 6:15 on Sunday night.)
MTIA
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/>
www.e-z-mrp.com <http://www.e-z-mrp.com/>