Multiple report copies with incrementing number
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?
|All times are GMT +5.5. The time now is 15:47.|