Change subform sourceobject

[Kamolas]

Hi

I have a form with several sub forms and i would like that when I press a commandbutton the source object of one of the sub forms change.

Can anyone help?

Thaks

 

[MarkK]

What have you tried so far that didn't work? Have you searched for "SourceObject" in Access help?

 

[Kamolas]

Yes, but i can´t call the subform that i want to change.
i have the code in the main form

 

[Kamolas]

maybe i should use frames and not sub forms...

 

[ShaneMan]

Hi

I have a form with several sub forms and i would like that when I press a commandbutton the source object of one of the sub forms change.

Can anyone help?

Thaks

Hey Kamolas,

I think what your looking for is this. On the cmdButtons OnClick event try this:
Me.subFormName.SourceObject = "NameOfForm"

Put the name of the form that you want to use as your SourceObject inside of parenthesis.

HTH,
Shane

 

[Kamolas]

So simple

Thaks

 

[ShaneMan]

So simple

Thaks

Your welcome. Glad I could help.

Shane