How come...

[Guest]

How come I can't use code to transverse from one sub-forms properties to
another sub-forms properties even when I fully quantify the forms name. This
seems pretty basic to me!

Thanks
Mike

 

[RuralGuy]

How come I can't use code to transverse from one sub-forms properties
to another sub-forms properties even when I fully quantify the forms
name. This seems pretty basic to me!

Thanks
Mike

You probably can! How about showing us what you have so far
and maybe someone here could see the problem.

 

[John Vinson]

How come I can't use code to transverse from one sub-forms properties to
another sub-forms properties even when I fully quantify the forms name. This
seems pretty basic to me!

Thanks
Mike

You can, if you do it right. It's not obvious though!

Me!Parent!secondsubform.SetFocus
Me!Parent!secondsubform.Form!controlname.SetFocus

You need both setfocus statements.

John W. Vinson[MVP]

 

[Guest]

John

This is where it stands now. The first - navigation - one works all of the
time but the second and third - navigation - work so inconsistantly I don't
know what is going on. Basically I need to turn off all of the filters for
all of my subforms.

The event is triggered from a subform
Forms![frmWIPExplorer]![sfmCustomerLetters]

Public Sub codAllFiltersOff()

Forms![frmWIPExplorer]![sfmCompanyNames].SetFocus
Forms![frmWIPExplorer]![sfmCompanyNames].Form.FilterOn = False

Forms![frmWIPExplorer]![sfmSONumbersLarge].SetFocus
Forms![frmWIPExplorer]![sfmSONumbersLarge].Form!strShopOrderNumber.SetFocus
Forms![frmWIPExplorer]![sfmSONumbersLarge].Form.FilterOn = False

Forms![frmWIPExplorer]![sfmSONumbersSmall].SetFocus
Forms![frmWIPExplorer]![sfmSONumbersSmall].Form!strShopOrderNumber.SetFocus
Forms![frmWIPExplorer]![sfmSONumbersSmall].Form.FilterOn = False

End Sub

Thanks
Mike S.

 

[John Vinson]

This is where it stands now. The first - navigation - one works all of the
time but the second and third - navigation - work so inconsistantly I don't
know what is going on. Basically I need to turn off all of the filters for
all of my subforms.

It's not necessary to setfocus to the subform in order to change its
properties!

Just leave out the SetFocus lines.

John W. Vinson[MVP]

 

[Guest]

John

Here is my original post. As far as the setfocus i had tried that
before.

Group

I have pasted code below. I can't get all of the filters to turn off
it seems that only the first and second one turn off but not the third. I
have used this in a click event and it didn't work then I pasted it into a
module and it didn't work either. I have started a new form and placed three
subforms on it and is still doesn't work.

Thanks
Mike


Public Sub codAllFiltersOff()
Forms![frmWIPExplorer]![sfmCompanyNames].Form.FilterOn = False
Forms![frmWIPExplorer]![sfmShopOrderNumbersLarge].Form.FilterOn = False
Forms![frmWIPExplorer]![sfmShopOrderNumbersSmall].Form.FilterOn = False
End Sub