Print report for 1 record

[Lapchien]

I've had a look on usenet but cannot find exactly what I want - and it
should be simple enough i guess..?

I have a purchase order database, nothing complicated, just a form based on
2 or 3 queries. The user enters the order, then I'd like them to be able to
print the order for sending to the supplier - it's a report already made
with same fields, etc.

Thanks,
Lap

[Con Giacomini]

I'm assuming that your form includes a field which is a primary key, such as
OrderID. If so, create a command button on the form whose OnClick event
triggers a macro to open the report. In the macro's Where Condition enter
the following:

[OrderID]=Forms![Name of Open Form]![OrderID]

Con Giacomini


"Lapchien" <cc****@nospamplease.eclipse.co.uk> wrote in message
news:10***************@ananke.eclipse.net.uk...

I've had a look on usenet but cannot find exactly what I want - and it
should be simple enough i guess..?

I have a purchase order database, nothing complicated, just a form based on 2 or 3 queries. The user enters the order, then I'd like them to be able to print the order for sending to the supplier - it's a report already made
with same fields, etc.

Thanks,
Lap

[Lapchien]

Perfect. Thanks.
--
Thanks,
Chris
cc****@NOSPAMeclipse.co.uk

"Con Giacomini" <co******@comcast.net> wrote in message
news:qwTnb.42637$275.94319@attbi_s53...

I'm assuming that your form includes a field which is a primary key, such as OrderID. If so, create a command button on the form whose OnClick event
triggers a macro to open the report. In the macro's Where Condition enter
the following:

[OrderID]=Forms![Name of Open Form]![OrderID]

Con Giacomini


"Lapchien" <cc****@nospamplease.eclipse.co.uk> wrote in message
news:10***************@ananke.eclipse.net.uk...

I've had a look on usenet but cannot find exactly what I want - and it
should be simple enough i guess..?

I have a purchase order database, nothing complicated, just a form based on

2 or 3 queries. The user enters the order, then I'd like them to be

able to

print the order for sending to the supplier - it's a report already made
with same fields, etc.

Thanks,
Lap