Chris, thank you very much for your responce. I do understand what your saying, but when I attempt it, it seems to not work. I copied the code you gave me, placed it in the Onclose section of the report. I changed where you put [YourFormName] to the title of the form. Do i have to change the [TheEditBox] to something that is specific to my form? When i open the report, everything is OK. When I close the report I get the following error message:
MICROSOFT ACCESS CAN'T FIND THE MACRO 'FORMS!ADDRESS LABEL!TheEditBox-" "
THE MACRO [OR ITS MACRO GROUP]DOSENT EXIST, OR THE MACRO IS NEW BUT HASN'T BEEN SAVED.
NOTE THAT WHEN YOU ENTER THE MACROGROUPNAME.MACRONAME SYNTAX IN AN ARGUMENT, YOU MUST SPECIFY THE NAME THE MACRO'S MACRO GROUP WAS LAST SAVED UNDER.
In my form, I have the following fields to enter on.
Address Line 1
Address Line 2
Address Line 3
City
State
Zip
Number of copies.
After i enter this information into the form, i run a label report. it knows how many labels to print by looking at the number of copies field. But after I'm done with this address label, I would like the form data to be deleted so I can start next time with a clean slate. Any further help would truly be appreciated.