I do try to open a report with a command button from a form, the report should be filtered depending on the users choice on the form.
FORM
Private Sub cmdPrint_Click()
   Dim stgFilter As String

I have created an invoice report that under the detail section shows the
Product Name, Size, colour and cost etc. My customers have the choice to make
stage payments at different times and the balance on the invoice gets updated
each time.