Hello,
I am trying to replace our debit memo form with access 2000. I have 2
tables (1 -- cust and other info, 2 -- items being returned -- 1 to many
rel). I have the form and report done. The report is generated by a query.
At the bottom of the report is a page designation (i.e., 1 page goes via
mail, 1 page goes to accounting, 1 page goes to warehouse, etc). These are
in 5 text boxes on the bottom of the report. I want to be able to click on
a print button on the form, and print 5 copies; however, for each copy, I
want to be able to change the font height and boldness for the different
areas (i.e., mail, accounting, warehouse, etc.) so that the user knows which
copy goes to which department. I put a print button on the form, and I
could add a loop, such as for next, to print 5 copies, but I don't know how
to modify the report for the different dept designations. Is this possible?

Also, my query has "[Debit Memo No]" in the criteria. How can I make it
only select the current information displayed on the form instead of an
input box asking me to key in the debit memo number (autonumber).

Thanks,
Brian