multiple entries in one form object

[Guest]

A would like to keep track of kits being produced; when the kit was sent and
what it contained. Each kit will have a unique barcode and each item will be
recorded by its barcode or batchcode. The kits may be comprised of as little
as one item, or may contain many items.

I have two tables, tblKitsSent and tblKitContents, in a one-to-many
relationship. The former table has the following fields: Test, KitCode
(PKey), DateSent, Lab.
The latter table has simply the fields KitCode and ItemCode.

The form on paper would simply
look like the following: With the info being stored in the
following:

Test:_____________________ tblKitsSents.Test
Kit Barcode:_______________ tblKitsSents.KitCode
Date Sent:________________ tblKitsSents.DateSent
Receiving Lab:_____________ tblKitsSents.Lab
Items:____________________ tblKitContents.Item,
tblKitContents.KitCode
(unique)
(Kit Barcode)
____________________ tblKitContents.Item,
tblKitContents.KitCode
(unique)
(duplicate of above)
____________________ tblKitContents.Item,
tblKitContents.KitCode
(unique)
(duplicate of above)
____________________ tblKitContents.Item,
tblKitContents.KitCode
(unique)
(duplicate of above)

etc. etc. (as many entries as required)

The data entry for Items will be manually keyed in (not a combo or list
box). How do I set up an Access form so that the Kit Code entry is
duplicated with each Kit Item when more than one item is place in the same
kit? Essentially, I am asking how to reproduce the paper form into an Access
form and have the Access form just as efficient.

Thanks (I know some basic VB programming---basic)

 

[Guest]

You need a form and a subform. The form should be based on tblKitsSent and
the subform on tblKitContents.

 

[Guest]

Yes, I figured as much, but how do I set up the subform for the varying
number of multiple entries?

 

[Guest]

Will multiple view in the subform allow me to enter more than one entry,
while automatically duplicating the kit barcode? I am working with 2002.

 

[Guest]

Got it. A handwritten note in the 2003 Tutorial I'm using led me to think I
could not use the subform so simply in 2002. Thanks for your quick response.

 

[Guest]

Glad you got it working. Sorry I was so long getting back. I was in crunch
mode. I assume you discovered that you use the Link Child Fields and Link
Master Fields properties to make that happen.