I use the code below in the Click event on my form to set the report filter. I now also want to set the recordsource of the report to the same as the form. How should I alter my code.
Private Sub cmdOpenReport_Click() 'I click on Print button on my form
DoCmd.OpenReport "rptqrytblBuilt", A_PREVIEW, , Me.Filter