Multiple report copies with incrementing number

[tcloster]

I have a form created from one table, the form has a lookup which finds products as the user types the product name in. When the user selects lookup record it gets loaded into the form.

What I am trying to do is have the user select the record and load it into the form (acheived this so far), then click a print preview button and be prompted to enter the number of copies of this report to print then ask them for a beginning number which will be added to an independant field on the report and be incremented by 1 for each copy of the report printed. (Access 2003) Is this possible?

[NeoPa]

The only way I can think of to do this, is to have a table (tblCount) with simple numbers in it as the whole record.
Before the process starts delete all records from the table.
Using DAO (or ADO whichever is the better version - I don't keep up with that), write some code that loops through creating records in this table to match the numbers you require in your report.
You have the Product code already in a field (txtProduct for instance) on the form (frmProduct).
Create a Report, whose Record Source is a query or SQL of the form :-

SELECT *
FROM tblCount, tblProduct
WHERE ([ProductID] = Form_frmProduct.txtProduct)

If writing the SQL within code, the last line could be done as

"WHERE ([ProductID] = '" & txtProduct & "')"