Changing a subform with code.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CD Tom - 01 Aug 2007 17:48 GMT

Ok, I have a form that the user select a individual from depending on the
Individuals number I would like to change one subform to a different subform.
Is there a way to do this in code?
Thanks for any help.

Reply to this Message

Douglas J. Steele - 01 Aug 2007 17:51 GMT

Me.NameOfSubformControl.SourceObject = "NameOfFormToUseAsSubform"

Don't forget to change the LinkChildFields and LinkMasterFields properties
if appropriate.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Ok, I have a form that the user select a individual from depending on the
> Individuals number I would like to change one subform to a different
> subform.
> Is there a way to do this in code?
> Thanks for any help.

Reply to this Message

CD Tom - 01 Aug 2007 18:24 GMT

Thanks that's what I needed.

> Me.NameOfSubformControl.SourceObject = "NameOfFormToUseAsSubform"
>
[quoted text clipped - 6 lines]
> > Is there a way to do this in code?
> > Thanks for any help.

Reply to this Message