How to save a filter in form & re use it in report ?

[digitalbalu]

In my db there is a customers form(datasheet) & customers report.
There is a print command button in the form.
If the End user applies filter & press the print button, only filtered records ( as in the form) should come in report.


What code should I write? How to save & re use the filter between forms & reports?
Please help me.. Thanks in advance...

[June7]

Options:

1. Report RecordSource query refers to the controls for filter criteria.

2. WHERE CONDITION argument of DoCmd.OpenForm (or OpenReport). Code refers to controls for filter criteria. Example:
DoCmd.OpenReport "report name", , , "customerID=" & Me.tbxCustomerID

[digitalbalu]

Thanks June7. I used DoCmd.OpenReport in VBA. Its working...