qurey and printing

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I have a form that comes from a query, when the Report #
is entered it brings up a single record. I need to print a
report from the current record that is displayed on the
form. This report also comes from the same query as the
form. Is there any way to make the print button print the
current record without asking the user to enter the report
# again ? Thanks
Doug
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you're using Access 2000 & greater you can use the OpenReport's
WhereCondition parameter. E.g.:

DoCmd.OpenReport "ReportName", WhereCondition:="RecordID=" & _
Me!RecordID

Where RecordID is the name of the control on the form that holds the
unique identifier for the current record.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBbeYYechKqOuFEgEQIphQCgt66euIUvZkxTWU9KDninyT4LDCYAnAsu
IBJA4dSBq6yW7e6E2BTpFqb9
=LJsT
-----END PGP SIGNATURE-----
 
Back
Top