Hi,
I have a registration form and a field on it for the user to add a number, could be any amount, probably usually between 1-50 but could be as high as a few hundred.
The table has an auto number field which is used as the sample number for the record. What I want to do is to add a number in the field on the form (Say 12), click on a button and then the database adds that number of records (12 records) to the table to take the next x number (x12) of the auto numbers (sample numbers). The fields will essentially be blank and updated from the Holding table later.
And then I want it to add those new x (12 records) to a holding table to use elsewhere.
Form: Sample_Registration_Form
Field: Number_Of_Samples
Table: Sample_Results
Holding Table: Registration_Holding
Anyone help?
Cheers
Jdlewin1
I have a registration form and a field on it for the user to add a number, could be any amount, probably usually between 1-50 but could be as high as a few hundred.
The table has an auto number field which is used as the sample number for the record. What I want to do is to add a number in the field on the form (Say 12), click on a button and then the database adds that number of records (12 records) to the table to take the next x number (x12) of the auto numbers (sample numbers). The fields will essentially be blank and updated from the Holding table later.
And then I want it to add those new x (12 records) to a holding table to use elsewhere.
Form: Sample_Registration_Form
Field: Number_Of_Samples
Table: Sample_Results
Holding Table: Registration_Holding
Anyone help?
Cheers
Jdlewin1