selecting options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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>
 
Back
Top