[AccessD] Filtering subform from parent form

I just googled "filter on an Access subform" and I suspected, got led
immediately to Allen Browne's site (and others). There are several hits. I'd
try Allen's first. IIRC A.D. Tejpal's written something on this. I haven't
had a need for this particular capability but google as I did and you should
get your answer.

HTH,
Arthur

On Sun, Sep 25, 2011 at 9:14 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> 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/>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>