sub forms

[xyz]

I have a moderate knowledge of Access and I am working to set up a database for a non-profit that I volunteer for. We want to have a form that parents can use to sign up their kids for summer camp. I have a form for the parents and a sub-form for the children's information. I want to add a button to bring up another sub-form for additional children. How do I do that?

Thanks.

[andy49]

Confused slightly xyz. What would the second "subform" do?


Sent from my iPhone using Tapatalk

[xyz]

I have the main form that ties to the table for parents. The sub-form is for the kid's information and ties to a table for camp attendees. I want them to be able to add more than one child and each child will be added to the camp attendees table. The director wants the form to say "more children" and a button for yes which will bring up another sub-form and a button that says no that will take them to the payment page.

[Missinglinq]

I have a form for the parents and a sub-form for the children's information. I want to add a button to bring up another sub-form for additional children. How do I do that?

To enter additional children you wouldn't 'bring up' a separate subform for each child, you would simply add another Record or Records to the already existing child's Subform.

Linq ;0)>

[Missinglinq]

I have a form for the parents and a sub-form for the children's information. I want to add a button to bring up another sub-form for additional children. How do I do that?

To enter additional children you wouldn't 'bring up' a separate subform for each child, you would simply add another Record or Records to the already existing camp attendees Subform.

Linq ;0)>

[xyz]

Okay. I think I have it fixed. We'll see when we test it tomorrow! Thanks.