Hi,
On a Form called "Class Size", the user annotates how many students via a combo box. I would then like a new form or even a subform to be created that contains data entry text boxes for the students name. Once names are entered, I would like to store each row as a record in a table.
If, user selects "X" from combo box on Form "Class Size" then a form/subform should appear with "X" rows of text boxes. Each row would have a box for First Name, Middle Name and Last name.
Right now, the only way I can get this to work is to have 8-10 different forms, each with varying student numbers and call the pertinent one up based on the combo box. This seems to be a very inefficient method to me, I just can't think of a way to make it efficient.
Suggetions will be greatfully accepted
On a Form called "Class Size", the user annotates how many students via a combo box. I would then like a new form or even a subform to be created that contains data entry text boxes for the students name. Once names are entered, I would like to store each row as a record in a table.
If, user selects "X" from combo box on Form "Class Size" then a form/subform should appear with "X" rows of text boxes. Each row would have a box for First Name, Middle Name and Last name.
Right now, the only way I can get this to work is to have 8-10 different forms, each with varying student numbers and call the pertinent one up based on the combo box. This seems to be a very inefficient method to me, I just can't think of a way to make it efficient.
Suggetions will be greatfully accepted
