[AccessD] Filtering a sub-subform

There is no filter currently.
I'm adding the filter through the afterupdate event of the combo box.
Thanks,
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Josh
McFarlane
Sent: Friday, June 10, 2005 11:21 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Filtering a sub-subform

On 6/10/05, Jim Hewson <JHewson at karta.com> wrote:
> 
> I'm having difficulty filtering a sub-subform in A2K.
> 
> The main form has subform1 which contains subform2.
> A combobox on subform2 filters the records, which works when the form 
> is opened as a main form.
> Subform1 is filtered using a listbox on subform1 and is not linked to 
> the main form.
> Subform2 is linked to subform1.
> 
> I need to filter the records in subform2 with the combobox and still 
> be able to edit and add records.
> 
> How is this done?
> 
> Jim
How are you filtering this at the moment? Are you filtering using
filters or by modifying the recordsource on the afterupdate event of the
combo box?

--
HTH
Josh McFarlane

"Peace cannot be kept by force. It can only be achieved by
understanding."
-Albert Einstein
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com