multiple entries in one form object

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
You need a form and a subform. The form should be based on tblKitsSent and
the subform on tblKitContents.
 
Yes, I figured as much, but how do I set up the subform for the varying
number of multiple entries?
 
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.
 
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.
 
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.
 
Back
Top