Printing Orders

G

gillj

I am playing around with a simple database, the purpose of which is to input
order details in a form and then print the order in question as a report.

I have designed the report to accept the order details, but am unable to
write a macro which takes me to the report in question for printing, rather
than the first report.

I would appreciate any help in resolving this issue.

gillj
 
A

Al Camp

Gill,
Each of your Orders records should have their own unique key field identifier. Use
that value in the query behind the report to filter your report for just the specific
record you want. Like an OrderID...
I have designed the report to accept the order details, but am unable to
write a macro which takes me to the report in question for printing, rather
than the first report.
Click to expand...

I think you mean your printing the first Order record (and probably all of them too),
instead of just the one you were viewing, when the report was requested.
 
D

DM

If you right-click in the query that you created the report from and then
click 'Totals' you get an extra combo box which will give you the opton for
the last record. However, this will only ever print the most recent record.

It might be better to have a button on the form that will print the current
record in the report. That way, you can click it when you create a record and
then click it again if you ever need to reprint a record.
 
Top