Multiple entries on a subform

[lipin]

I have a main form for data entry with about 5 textboxes and then there is a button to make the subform visible. Now the subform has about 10 textboxes that need input. And usually there are anywhere from 1 to 6 records that need to go on the subform. For most of the records entered on the subform, most of the textboxes will need the data entered in the first record and only one or two fields will differ. Is there a faster way than to input all ten fields for each record when they are alike? I was using a single form view on the subform, but maybe I should change to continuous? And somehow carry info from rec 1 to rec 2

Kind of like this on the subform:
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 n 7 8 9 10
1 2 3 m 5 6 7 8 9 10
Is there a way for each record to get the 1 thru 10
and then I can just change the ones that need changed?

Thanks.

 

[David R]

There are ways to do what you're asking..

The bigger question is, why do you need to store the same value in two places? If you revamp your structure, you may be able to achieve several benefits:
1) less code and complication, making maintenance less of a hassle;
2) smaller tables with less fields, decreasing the size of your database;
3) a properly organized structure that keeps yuor data up to date and valid.

Can you explain in basic terms what function your form-and-subform have? Data-entry examples like yours don't always give the clearest vision of what you're trying to do.

Please post back with more information and someone can surely help you,
David R

 

[lipin]

Here's what is in the form(This application is used by warehouse auditors): 6 textboxes

txtCartonNumber
txtEmplID
txtUnitsInCarton
txtSOunits
txtAuditType

If there are no errors in the carton great, they go to the next record. If errors do exist they click "errors" button and get the subform to enter the error information.(the 10 fields in original post are on the subform)

Say there are 8 errors to recordin a carton, all 8 could be charged to 8 different employees depends what type of error it is, or 4 errors to 2 employees each, etc, etc.

Now if 1 employee filled the carton wth 8 different garments all of which are different wrong sizes, as is is now the auditor has to fill out 10 fields for each error when all the fields are going to contain the same info except that the size field will be different for each error. I am trying to get it to where they can enter error 1 of 10 and then only enter the wrong sizes for errors 2 thru 10.

Hope this is a little clearer. Thanks.