selecting options

I

idcreek

I have a report that has items on it with catalog numbers and vendors. The
catalog numbers and vendors come form a table called ITEMS. In that table I
have alternate catalog numbers and vendors. How can I get my report to let me
select an alternate vendor and cat. number?
 
J

Jeff Boyce

One approach is to use a "report order" form. Create a new form, add
one/more combo boxes that you use to select the values you use to filter the
report.

Add a <Print Preview> command button and build a WHERE clause/filter
statement dynamically, in the code behind the <Print Preview> button, using
the values selected on the form. As a last step in the code behind this
button, open the report, filtered...

Good luck

Jeff Boyce
<Access MVP>
 
Top