[AccessD] Filtering subform from parent form

Rocky Smolin rockysmolin at bchacc.com
Sun Sep 25 23:12:42 CDT 2011


The first thing I see is a suggestion to build a SQL statement with the
filtering parameters in the WHERE clause.  I suppose I could try that as a
workaround.  Annoying that the .Filter doesn't seem to work as it should,
though.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, September 25, 2011 6:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Filtering subform from parent form

I just checked the first posting and there's a reply from Allen himself:

> With Me.Child0.Form
> .Filter = "ExternalEvents Is Not Null"
> .FilterOn = True
> End With

His Filter above was specific to the question he was asked, of course. He's
assuming that your filter command button is on the main form, which seems
logical enough, but it may mean that you cannot use the built-in
Filter-By-Form thing, and instead may have to create your own dialog for
this situation. If it's always the same fields, then that shouldn't be a
problem.

Another approach: you could open a dialog based on the subform's record
source, then filter it by form, then grab the Filter property, close the
dialog and plug the filter into the above code, which would live in the
parent form.

Arthur

P.S.
Interesting exercise. I think build a little toy program and see if I can
make it work.

On Sun, Sep 25, 2011 at 9:23 PM, Arthur Fuller
<fuller.artful at gmail.com>wrote:

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




More information about the AccessD mailing list