Acess 2000 Query and report problem.

[Vivian]

Hi, anyone there care to offer some advice. How to
produce the sequence from combo box to command button
and finally producing the report according to the
month selected or years keyed in? Currently, report
has been created without using queries and what has
been displayed is the report of all the months and
years. Thanks for your advise!

vv

 

[Howard Brody]

Run your report from a form and, for this example, make
sure the form has a ComboBox for selecting the date
(cboDate) and a CommandButton to run the report
(cmdRunReport).

You can do this one of two ways:

Build a query to use as the source for your report and

use the cboDate as the criteria in the query.

When it opens, code your report to filter its data,

using the cboDate as the criteria.

I do both, depending on the project and needs, but
building the query is the quicker and easier method.

Hope this helps!

Howard Brody