Auto generate records

[RokitRod]

I would like to make a table in my database to assign records. We use numbered "seals" when we do inspections and I would like to assign those seals to users so they can later be entered as part of the inspection data. Essentially I want to pu in a date, the user they are assigned to and the start and finish number of the seals. When I enter the form it appends the "seals" table with the number of records that I have just added.

[pbaldy]

You mean you'd enter 1 and 10 and expect 10 records to be added to the table numbered 1 through 10? Wouldn't be difficult; you'd use a For/Next loop with the two values as the range, and within add the records using the counter value plus your other values. It would be a little like this:

http://www.baldyweb.com/MultiselectAppend.htm

But with a For/Next loop instead of the listbox loop.