Print only one Record

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

Guest

I have a tabel that is fed certain information about PO's as well it has
other fields that will need to be poplulated, I also have a form based off
this table and this is where the user will fill in the extra data needed. On
the PO's there is a SHIP TO address and a Forwarding address. I also have two
reports, one report will print the PO with the SHIP TO address and one will
print a report with the Forwarding Address, the user will need to make that
decision at the time they enter the data.

My question is how can I put two "print" buttons on the form that will allow
the user to make this descision? Meaning I would like it if they clicked on
button 1 the report would print for the current record with the SHIP TO
address, and if they click on button 2 the current record would print with
the Forwarding address.

Sorry for the long explaination but I wanted to give all details that I
could, I am under the gun on this one. Any help is arreciated!
 
If it were me, I'd use one button, but I'd add two radio buttons on my form
in a group box called "Address to Print:" I'd label one button as "Ship To"
and make it the default. I'd label the other "Forwarding".

I'd then use an IIF statement in an unbound text box on my report to print
the appropriate address.
 
Alan

Adding another <Print> button when you add another report can get out of
hand <g>!

Rick's suggestion will work if you will only ever have 2 (or maybe 3)
different reports, but can still get out of hand when you have more.

Another approach would be to list the available reports (in a combo box or a
list box), and have a single <Print> button that uses the selected report to
know which one to open.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top