Acess 2000 Query and report problem.

  • Thread starter Thread starter Vivian
  • Start date Start date
V

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
 
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
Click to expand...
use the cboDate as the criteria in the query.
When it opens, code your report to filter its data,
Click to expand...
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
 
Back
Top