Ideas for a form to generate sublots?

[dnr]

Hello!

I am hoping someone can help with some code ideas for this. I have a
database in microsoft access, that we track what is happening to our product
on an individual basis. We run our process in batches which is assigned a
lot number, and each batch has multiple product in it which are assigned
sublot. So..

For instance if you had a bag of M&M's, that bag would have a lot number,
let say it is lot number one. Each M&M in that bag would have a sublot
number, if there were three M&M's in the bag, they would be labeled 1-001,
1-002, 1-003. There is not always the same number of M&M's in the bag, which
is where my issue comes in.

I am looking for a form that the employees could enter the lot number and
how many products are in that lot number. Then they would press a button
called "Generate Batch" and it would produce lot number - sublot for each
product, which they could then enter information for.

Does anyone have an idea how to do this?

Thanks - dnr

 

[KARL DEWEY]

You might try how I responded to this one --

How do I increment table entry a specified # of times?
I am creating a serial number table. User will enter prefix, I need to make
a table entry incremented by 1 for a specified number of entries.

Example:

791456-01
791456-02
791456-03

User inputs "791456"
-------------------------
Create a table named CountNumber with field named CountNUM containing number
from 0 (zero) through your maximum spread.
INSERT INTO YourTable ( SN )
SELECT [Enter Starting Serial #]+[CountNUM] AS Expr1
FROM CountNumber
WHERE (((CountNumber.CountNUM)<=[Enter qunaity of records]-1));

Reference the textboxes on the form instead of [Enter Starting Serial #]
and [Enter qunaity of records] to enter data from form.