Update Table from Report

[bbeeching]

have an Address application I'm building that I need some VBA assistance with. I have a table tblAddress and a tblCorrespondence. I would like to Update tblCorrespondence when a label report is printed. The label report can be sorted by several parameters. In tblCorrespondence I'm using check boxs for SentFlyer, and FlyerReturned with text boxes for SentDate and Date returned. What I'd like to have happen is when the user Prints (not preview) the selected labels, the tblCorrespondence.SentFlyer and tblCorrespondence.DateSent fields are updated for those AddressID's selected. I know that it involves some kind of loop but this is way beyond my skills. I'm at the point that I understand some basic VBA but some of this is still greek. Thanks for the help!

 

[Rich]

Use an Update query or the SQL, no loop is required,just set the criteria to your report. You might like to include a message box to confirm the records have actually printed

 

[bbeeching]

Thank You Sir. I will give it a go.