ACC2000 'query date' issue

[BrentDA]

My database has a date table with 'manually keyed' weekly date ranges (1
record/row in the table per week/date range) that show as combo box drop-down
lists in several of my forms.

I'm trying to create a report so that when you open the report, it offers
that same combo box drop-down list to users so they can choose a date range.

Is that done with a query, or is there code that I can put directly in the
report?

Thanks in advance for your help !

Brent

 

[Allen Browne]

Answered in m.p.a.reports.

 

[John W. Vinson]

My database has a date table with 'manually keyed' weekly date ranges (1
record/row in the table per week/date range) that show as combo box drop-down
lists in several of my forms.

I'm trying to create a report so that when you open the report, it offers
that same combo box drop-down list to users so they can choose a date range.

Is that done with a query, or is there code that I can put directly in the
report?

Thanks in advance for your help !

Brent

Reports aren't interactive, so you can't have a combo box on a report that
allows a selection. Instead, put the combo box on a Form (an unbound form,
with no recordsource, so you don't affect data in your tables); use code in
the combo's afterupdate event or in the Click event of a button on the form to
launch the report. The Report can be based on a Query referencing the form
control.