By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Print report for 1 record

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.