Command Buttons calls Forms

  • Thread starter Thread starter Tom
  • Start date Start date
T

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.
 
Tom said:
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.
Click to expand...

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

Me.SubformControlName.SourceObject = "FormName"
 
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.
 
Back
Top