Command Buttons calls Forms

[Tom]

I need some help with command buttons and form.

I have 3 forms... (naturally) they all have different fields.

Now, I want to create a blank form (let's call it "frmCommands") and add 3
command button in its header.

Then, when I click on either one of the 3 command buttons I want the
associated form appear in main body of the frmCommands.

How would I go about it? More specifically, how do I make either one of the
3 forms appear (dynamically) based on the click of the command button.

 

[Rick Brandt]

I need some help with command buttons and form.

I have 3 forms... (naturally) they all have different fields.

Now, I want to create a blank form (let's call it "frmCommands") and add 3
command button in its header.

Then, when I click on either one of the 3 command buttons I want the
associated form appear in main body of the frmCommands.

How would I go about it? More specifically, how do I make either one of the
3 forms appear (dynamically) based on the click of the command button.

Use a subform control with no default SourceObject. Then in each button's
click event...

Me.SubformControlName.SourceObject = "FormName"

 

[Tony C]

Add a Sub Form to the master Form, have the command
buttons update the content of the Sub Form whenever one of
the buttons is clicked.

Remember to set a default at "Form Open".

TC.

 

[Tom]

Rick:

Thanks for sharing the info w/ me... this works perfect!!!