I want a command button that previews a report for only the curre.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jingo - 15 Mar 2005 17:39 GMT

How do I use the command button on a form to print preview a report for only
the one record I was viewing in the form? It use to work in 2.0 but doesn't
in 2000 or later versions.

Reply to this Message

Allen Browne - 15 Mar 2005 17:45 GMT

See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

The article shows how to make sure the record is saved and that there is a
record to print, and then use OpenReport with a WhereCondition that limits
it to the current record in the form.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> How do I use the command button on a form to print preview a report for
> only
> the one record I was viewing in the form? It use to work in 2.0 but
> doesn't
> in 2000 or later versions.

Reply to this Message