dynamically change sub form (using code) on button click...

  • Thread starter Thread starter Philip
  • Start date Start date
P

Philip

Hi,

I have a form and the subform allows users to view data or modify data in
the table.

But for adding new records, I want a simplified view of the table, with only
therequired columns to be shown in the sub-form.

How can I either change the subform to be opened when the user clicks 'Add
New' or hide all the fields that are optional?

thanks

Philip
 
You can change the form serving as the SourceObject of the subform easily
enough by including :

Me.MySubForm.SourceObject = "frmMySubForm"

in the OnClick event of the "Add New" command button on the main form.

-Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Populate sub form 1
Set Change Event on Control from Nested Subform 0
Problem with sub-sub-form 2
Filtering a main form based on a sub-form 6
Trouble Filtering a Sub Form With Combo Box Options 2
Forms & Sub Forms 12
Very Simple Question 1

Back
Top