Showallrecords resets all filters in my tab-subform Main Form

[aunixguru]

I have a main menu that is really a tab control with many subforms on it.
Some of the subforms have subforms as well.

All subforms link to the main tab control form called Projects. (access 2000 by the way)

I have a dropdown that list all projects and the user selects the project to work with with an applyfilter command. (this works)

Each subform is linked to the project so their particular records come up after the apply filter. (works great)

Here is the problem. I have a subform under projects called quotes. There can be many quotes for each project. The subform is not continuous as there is too much data.

I have a dropdown in the subform of quotes to find a particular quote. (again this applyfilter to this subform works)

The problem is this. The main project form as well as the quotes subform have a button that does a docmd.showallrecords on it. When either one is pressed, it resets the filter for both the project form and quote subform.

If I am in the quote subform and hit showallrecords , I only want it to apply to that subform , not my top level form.

Is there any way do to this?

Is there another technique I should be using?

Thanks, in advance

 

[Aivars]

Hi!

dim frm as form
dim frmSub1 as form

set frm=forms("MainFormName&quot
set frmSub1=forms("MainFormName&quot("SubForm1&quot

frm.filteron=false
frmSub1.filteron=false

Aivars

 

[Aivars]

Sorry!

I took any mistake before.

dim frm as form
dim frmSub1 as form

set frm=forms("MainFormName&quot
set frmSub1=forms("MainFormName&quot("SubForm1&quot.form

frm.filteron=false
frmSub1.filteron=false

Aivars