Dear friends,
I want to print some records from a table. I created 3 buttons which one for selecting for printing (yes/no) the others are for prewieving and printing.
How can I reset the selection field after printing. Thank you very much for your answers.

You'll need to run an update query to reset the selections.

BTW, this is a poor method for a multi-user application since only a single user would be able to use this feature at one time.

A better way to to selections is to use a separate work table. If this table is in the back end (where it must be if the be is SQL Server), the table needs to includ a column to identify the user. That will allow multiple people to be using the same function at a time. Start by running a delete query to delete all selected rows for a particular user. Then do you selections. Base your reports on a query that joins to the selection table.

Dear Hartman,
Thank you very much for your kind reply. As your advice I updated the print selection by a query and depressed system messages for that event.