Command Buttons calls Forms

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.

--
Thanks,
Tom

"Tom" wrote in message
...
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"


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

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.
-----Original Message-----
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.

--
Thanks,
Tom



.

Rick:

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

--
Thanks,
Tom


"Rick Brandt" wrote in message
...
"Tom" wrote in message
...
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"


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com