How to Print Selected Record Only

[Ellen Koch]

I have an access db and when I ask it to print it insists on printing all of the records together instead of the one I have open. What am I doing wrong?

[NeoPa]

As the question is asked so inadequately I'm left guessing what you actually mean. That's the biggest mistake of course.

As for your database design though, I would guess you're trying to print a form instead of a report. That's possible of course, but it's not really what they were designed to do. They will print the current recordset, and not simply what's currently visible at the time of printing.

To handle printing the current record then design a report (or form actually, but a report is probably more sensible as that's what they were specifically designed to provide) to show the details you want and open it with a filter provided that includes only the record(s) that you want included in the printed report.

[pdebaets]

If your record id is a text field, you'll need to surround Me!MyRecordID with chr(34) like so

DoCmd.OpenForm Me.Name, acPreview, , "MyRecordID = " & chr(34) & Me!MyRecordID & chr(34)

Where MyRecordID is the name of your unique record ID field.

[NeoPa]

PDEBaets:
If your record id is a text field, you'll need to surround Me!MyRecordID with chr(34) like so

That's not actually quite true. That is one way of handling quotes in SQL but not a good way. Quotes should simply be used as is :

Call DoCmd.OpenForm(Me.Name, acPreview, , "MyRecordID = '" & Me.MyRecordID & "'")

There is absolutely no need to confuse matters by using Chr(34), or even a more standards compliant version - Chr(39) (See Quotes (') and Double-Quotes (") - Where and When to use them).

Your point about needing quotes though (unfortunately masked rather than illustrated by the code example) is a good one and may prove helpful.