Update table when form is printed

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

I'd like to update a column in my table when a report that prints labels has
been run. I've used the label wizard (reports) to use a query that returns
all addresses that haven't been printed to a label. Once I print those
labels I'd like to update the column (Yes/No) to show that I've printed
those addresses. What's the easiest way to automate this?

Thanks,

Colin
 
Add a button to your form that the user can click when they've got the
labels, and run SQL to update the column.

You don't want to automate it any more than that, in case something goes
wrong with the printing.
 
Currently I've got a report that creates a nice layout for my printing
labels. I don't think I could add a button to this report. From a form how
would I do the following:

1. From a form open the report I'd like to print
2. Lock table so no updates can be made while printing reports
3. From form update column to signify it 's been printed.
4. Unlock table.
 
OK. After fiddling around I figured out how to print a report (just add
button to form and choose print report). Sorry, new to Access. OK. Main
thing I need to do is lock table from changes when my form that prints
report is open.
 
Back
Top