Multiple Labels

[honey2wood]

Hi All,
I have a database that I need to print labels from. I want to be able to select an address and print a single label, any number of the same label or different addresses..
I have gleaned enough information from this and other forums to now have a form with a list of addresses with a field at the end where I enter the number of labels I need for one or more of those addresses and it will print the labels. It works !!! and i am able to print as many of the same or different addresses as I need.
The only thing I cant think how to do is clear the numbers entered in the fields when I close the form so that next time it is all 0's again
The form is made from a query and the 'Labels needed' field has a default of 0. All I need to do is clear the numbers back to the default when finishing with the form
I hope this explains the problem. It is almost certainly a simple process but I just cant think.
Thanks for looking.
Graham

 

[sneuberg]

Sounds like there's a field which stores the number of labels in some table that you want set to zero when the form closes. You could try something like:

CurrentDb.Execute "Update [table that has the field] SET [Field with number of Label] = 0"

in the form's close event.

 

[honey2wood]

Hi Sneuberg

That has worked just fine thank you.
Graham