Feb 21 2005, 01:49 PM
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.
Feb 21 2005, 02:01 PM
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.
Feb 21 2005, 03:26 PM
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 -
Feb 21 2005, 03:34 PM
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...
Feb 21 2005, 04:11 PM
Thanks Jack - Works like a charm.
Feb 21 2005, 04:25 PM
You are welcome and continued success with your project....
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here