I am developing a lessons learned db to track issues and solutions. I have been utilizing forms as:
1- a user interface with options for filtering the data
2 - displaying the filtered data.

My question is - given a form which displays lets say 20 filtered records - Is there a way for the user to
select any one or number of those and have access print them? Initially I tried putting check boxes
next to the record, but if one was selected, then all were selected. Now, I have no idea where to
begin. Any help would be greatly appreciated.

Jas

If you added a check box and checking one checks all then I assume you have a Continuous form and the checkboxes are not bound. If you bind the check boxes to the form then you can base the report on a query that is filtered to show only the checked records.

hth,
Jack

Hi Jack - thanks for you help. I have another follow up question - I am new to VB and SQL - is there a simple oide I can write to perform the printing operation (i.e to print the records selected), and also to automatically reset the check boxes to "unchecked" status after printing? What's the best way to go about this do you think?

Thanks again -
Jas

You only have to create a query with the Criteria for the check box is set to True. Use the query as the Record Source for your repoort. Just opening the report will print the selected records. To clear the check boxes create an Update Query and set the check box to False and the criteria to True. Now all you check boxes will be cleared and ready for the next time. You can run the code from the On Close event of your form, if you like, or the On Close event of the report...

hth,
Jack

Thanks Jack - Works like a charm.

You are welcome and continued success with your project....

Jack