Okay, I've created a form which has a field for the data entry person to input the number of children that the perspective client has. I will also need the names and the DOB of each one of those children. Now, is it possible for a subform or subforms to be created with fields for the Last Name, First Name and DOB of the children in the exact number that ther person selects for the amount of children in the home?
I know it sounds confusing, so let me explain. So, after the data entry person puts, let's say, 3 kids in the home, either a subform with 3 records, maybe in datasheet view, for each one of the kids is created or 3 successive subforms are created (with each to be completed one after the other) for each one of the kids. The trick would be, the number of records (in the subform in datasheet view) or successive subforms would depend on the number selected in the "number of children in household" field.
I hope I've explained myself adequately. Any suggestions would be appreciated. Thank you.
I know it sounds confusing, so let me explain. So, after the data entry person puts, let's say, 3 kids in the home, either a subform with 3 records, maybe in datasheet view, for each one of the kids is created or 3 successive subforms are created (with each to be completed one after the other) for each one of the kids. The trick would be, the number of records (in the subform in datasheet view) or successive subforms would depend on the number selected in the "number of children in household" field.
I hope I've explained myself adequately. Any suggestions would be appreciated. Thank you.