User selected records for report

[SueBK]

I would like to give users the option of selecting any records from a particular table ("I want this one, that one and those two") to print to a report.

I'm thinking that process would be:
* add a "include to print" yes/no field in the table
* create a continous form against the table; allow edits against the checkbox (not edits in my database at present)
* create query that filters against selected checkboxes
* create a report that runs off that query

All this I can do. BUT I want the selected checkboxes to return to unselected once the form is closed. How do I do that?

 

[Beetle]

Update the table using VBA when you close the form, or at some point after the report has been generated.

Dim strUpdate As String

strUpdate = "Update YourTable Set PrintRecord = False;"

CurrentDb.Execute strUpdate, dbFailOnError

 

[SueBK]

I found this tutorial that does exactly what I want:
http://www.techrepublic.com/blog/ho...ords-for-a-dynamic-label-report-in-access/168