Filtering a report

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hello group. I'm really stuck and don't know what I'm doing here so any
advice would be appreciated.

Every client has alot of companies that they owe money to.
I have a report that is based on a query.

I would like the user to select a client, click the print button and the
report will produce a list of the compainies they owe money to.

Help.
 
Chris said:
Hello group. I'm really stuck and don't know what I'm doing here so any
advice would be appreciated.

Every client has alot of companies that they owe money to.
I have a report that is based on a query.

I would like the user to select a client, click the print button and the
report will produce a list of the compainies they owe money to.
Click to expand...

The OpenReport Method of DoCmd includes an optional WHERE argument where you can
specify a filter for the report when opened. Check the Help file for specifics.

For example, if you were using a form and selected a Company from a ComboBox
named CompanyID the command would like...

DoCmd.OpenReport "ReportName", acViewPreview,, "CompanyID = " & Me.CompanyID
 
Back
Top