Print Selected Records from a Table in a Report

[jeffyyy]

I have a table with records that I would like to be able to print on a report, but I want to select which ones print. Basically this is an exercise sheet that I would like to pick which records that print on this sheet. I want a form with check-boxes that I would select the various exercises (each with their own record in the table), If I select an exercise it would print that out on the report, if not, it does not print.

Thanks for any help in advance!

[NTC]

Add a checkbox field to your underlying table - for this purpose.

Then you can have it in your form.

Source the report on a query - and set that query on the table with the criteria of the checkbox to be 'yes' (or -1) .

(also to be elegant you may want a DeleteQuery that runs at some point to clear away all the check marks from the table)

Hope this helps.

[NTC]

actually - not a DeleteQuery - but an UpdateQuery to change/remove those 'yes'.... sorry about that typo....