Print Button Code:

Private Sub PrintBTN_Click()
    
    DoCmd.OpenReport "TalkingPointsReportSimplified_IsSelectedOnly", acViewPreview
    
    CurrentDb.Execute "UPDATE tTalkingPoints SET isSelected = False WHERE isSelected = True;"
    Me.Requery ' Refresh the form to update the checkboxes

End Sub

After I get the preview I make everyting unchecked so others aren't getting gooned up by another persons selection.

Let me clarify - its limiting to two records. Not just two pages. If I open the report not using the button - and only having items checked - everything I checked is showing up.

Sorry for the lack of full pictures of the database. Some of the information is not approved for public release and I had to demo the current version using relevant data.

Also add a Me.Requery before opening the Report.

Hi Jasen, you unselect the records while *the report is still opened*.  That is the reason your report doesn't show all the selected records.  Put the CurrentDb.Execute statement somewhere else, such as in the Close event of the report.  The only good time to unselect the records is when the user is closing the report.

Kevin R - The is only opened when using that button. So it should never be opened when using the selection boxes. For the form itself? I used this to get rid of dirty records in this form:

Private Sub SelectBox_AfterUpdate()
    ' Save the current record immediately after the checkbox is updated
    If Me.Dirty Then
        Me.Dirty = False
    End If
End Sub

Kevin Y - it shows some of the records, not all of them. The unselect happens AFTER the preview is generated.

Update: I think it was the ONE record (the first one) that was causing the issue. If i don't select it, everything works as expected. I deleted the record and created a new one for it and now it seems to be working.

>> The unselect happens AFTER the preview is generated

The preview is NOT completely generated -- only the *first page* is shown when you open preview.  The user has to click the next page button at the bottom to see the next page.  But your code to unselect the records has already been run before the user goes to the next page, at which point the user will likely see nothing.  As I said, you cannot make any unselection until after the report is closed, or at least the last page of the report is shown.