Report based of filtered data from a form

[Fabdav]

I have a form displaying data pulled out from a query
I am filtering the data from the form (filter by form, clicking in the filter bottom, etc)
I would like to create a report which displais ONLY the record displayed in the form after the fileter is applied and not all the records that are originally displayed by the query
Is this possible

[alansidman]

Here is some code that I use that is attached to a command button (Command28). The report is named Submission. You need to reference the Record ID shown in the DoCmd line for the particular record you want to show in your report. You will have to change your Form Name, Report Name, Command Button Name and Record ID to match what is in your Database.

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

    Dim stDocName As String

    stDocName = "Submission"

    DoCmd.OpenReport stDocName, acViewPreview, , "[ID]=Forms!frmClients!ID"

Exit_Command28_Click:
    Exit Sub

Err_Command28_Click:
    MsgBox Err.Description
    Resume Exit_Command28_Click
    
End Sub