Tabular Control Code

[benthamq]

Hello All,



I am new to Access 2010 and greatly appreciate any help you can offer.

I have a form with a tabular control and one of the tabs contains a subform.

I want to put a button in the subform that will automatically create another tab in the tabular control with another blank copy of the subform in it. I need to do this because the subform contains data from a query that is in a many to one relationship with the data in the main part of the form, and it is possible sometimes that the user will need to enter additional records in the subform for the one record that is in the main part of the form. By having a button that automatically opens a new tab with a blank copy of the subform he will be able to do so easily.

What code should I write for the click event of the button on the subform to accomplish this?

Thanks so much for any help!

[June7]

Cannot open duplicate instances of the same form. What you need to do is move to a new record of the subform. The subform is set for SingleForm view?

[benthamq]

Thanks for your reply.

I guess my initial question was pretty dumb. Noted that you cannot duplicate the same subform. I am still learning.

So the solution then is to have multiple records in the subform - understood.
That brings up this related question:
When the form is opened, therefore, I need it so that the only records available in the subform are ones that apply to the open record in the main form (plus the option to add a new record in the subform, of course.)
How can this be accomplished? It seems like I would have to use the primary key field of the record in the main form to set a filter for all the records in the subform but I don't have any idea what code to write for this.

Sorry if this is very tedious question to answer - thanks for your help.

[June7]

A subform is really just a form. What makes it different is that it is held in a Subform Container Control. This control has Master/Child link properties that will synchronize the recordsets of the main and sub forms. Set these properties to the primary and foreign key fields of the two forms.

Even if a form is set to SingleForm view, its RecordSource can still be multiple records. Just depends on the filter criteria. The view setting just determines if you can see more than one record at a time, as in Datasheet View. The navigation bar will allow you to move from record to record.

[benthamq]

"This control has Master/Child link properties that will synchronize the recordsets of the main and sub forms. Set these properties to the primary and foreign key fields of the two forms."

Would it be possible for you to explain how to set the master/child link properties? Is this the same as creating a relationship?

Also, what is the general wisdom, if it exists, regarding basing a form on a table versus basing a form on a query? I know sometimes you must base it on a query if all the fileds you need to update are not present in the table but if they are, is it OK to base the form on the table?

Thank you very much.

[June7]

Master/Child links are properties of the subform container control. Select the container, open Properties dialog, go to Data tab. It is like creating a relationship, but only for this form/subform. If you have established relationship in the Relationship builder, then the control might automatically set the links when it is created on the form, or maybe that requires using wizard which I never do.

I have seen advice against table as direct recordsource but I have never experienced an issue with basing a form/report on a table, however, most of my forms/reports are based on a query because usually need joined tables.

[benthamq]

Thanks - At first, I couldn't find the subform container control to set the master/child link properties but now I have and I have done exactly as you explained and the form/sub form are working perfectly together.

I will mark this solved.

Thanks again.