Selected Record Print ???

[Jay Wilson]

I have placed a "Print" button on a form. When I press the button, I want
to print only the record that I am currently looking at. When I press the
button, I get all records in the table.

I tried the following, to limit the record to the currectly selected record
and I still get all records.

DoCmd.PrintOut acSelection

I then tried the following and get an error message that the Currently
Selected isn't available.

RunCommand acCmdSelectRecord
DoCmd.PrintOut acSelection

What am I doing wrong?

Thanks

 

[Mike Painter]

I have placed a "Print" button on a form. When I press the button, I
want to print only the record that I am currently looking at. When I
press the button, I get all records in the table.

I tried the following, to limit the record to the currectly selected
record and I still get all records.

DoCmd.PrintOut acSelection

I then tried the following and get an error message that the Currently
Selected isn't available.

RunCommand acCmdSelectRecord
DoCmd.PrintOut acSelection

Run your report from a query.
Even if you don't print it have the record key in the query.
The criteria for that field in the query will be
Forms!YourFormName!YourKeyFieldonForm

 

[Albert D. Kallal]

I would strongly suggest you built a report.

Once you made the report, then it is a simple matter to send the CURRENT
record to that report.


The code behind the button looks like:

me.Refresh ' write the record to disk for report
docmd.OpenReport "YourReprot",acViewPreview,,"id = " & me!id

The above will print the one record. If you remove the acViewPreview, then
you will not get a preview, and it goes right to the printer.