Open forms in subform control from switchboard

[Andi]

Does anyone know how to set a subform to populate based on the choice from a
switchboard?

I have created a switchboard as an option list for various medical
conditions but rather than open each "condition" form in a new window, I
would like it to appear on the side of the switchboard as a subform (It would
be prettier that way)

Any sugestions?

Thanks

 

[Alex Dybenko]

Hi,
you can use subform control's SourceObject property to assign selected form
name

 

[Larry Linson]

If you created the Switchboard yourself, with unbound Form(s) and Command
Buttons, what you want to do is not difficult.

If you created it with the Switchboard Manager (IMNSHO, a complex solution
to a simple problem), I can't advise you, because there are interactions
between the Forms and a Table that I never found it worthwhile to explore.

Larry Linson
Microsoft Access MVP

 

[Andi]

I have about 20 different forms I need to appear on the subform at different
times. If the Head button is pressed frmhead would be on the subform, if Back
button is pressed the subform would change to frmBack. Can this be done using
SourceObject property?

 

[Andi]

I have modified a Switchboard Manager switchboard. However, I can easily
creat my own if it would make it possible to create this. What do Ineed to do?

 

[Alex Dybenko]

Yes,
say for Back button click event write a following code:
me.subform1.sourceobject = "frmBack"

 

[Andi]

Thanks. I'll try this right away.

Yes,
say for Back button click event write a following code:
me.subform1.sourceobject = "frmBack"

 

[Andi]

This did work. Thanks!

Thanks. I'll try this right away.