Help with subform?

H

Harry H

Hi all, I have a mainform, then there is a subform within a page Tab-control.
How do I, using VBA, change the source object of the subform? I have tried
open the mainform as acdesign, and use

forms!mainform.mysubform.form.sourceobject="newsource"

and it failed to make the change. Any help is appreciated. Thanks.
 
D

David C. Holley

As I seem to recall the source object cannot be changed during runtime.
Others here are free to correct me if I'm wrong. The RecordSource,
however, can be changed freely.

David H
 
M

Marshall Barton

Harry said:
Hi all, I have a mainform, then there is a subform within a page Tab-control.
How do I, using VBA, change the source object of the subform? I have tried
open the mainform as acdesign, and use

forms!mainform.mysubform.form.sourceobject="newsource"

and it failed to make the change. Any help is appreciated. Thanks.
Click to expand...


It's not the form object you want to modify, it's the
subform **control** that has the SoureObject property.
Assuming the code is somewhere in the main form's module:

Me.mysubformcontrol.sourceobject="newsource"

No need to go to design view for this.
 
Top