Adding a Print Command button, that only prints page on screen

[Guest]

I am a novice to access and need help. I added a print command button to my
form, but when I try to use it, it wants to print every record. I just want
to print the current record that is viewed on the screen. Can someone help me
pls?

 

[Allen Browne]

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

 

[Lynn Trapp]

Karen,
What I usually do is add a parameter to the query that is the Record source
for the report. That parameter will reference the textbox that displays the
primary key for the table behind your form. The general syntax for that
parameter is:

Forms!YourFormName!YourPKFieldName

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Thank you Allen. If you could help me out a little more, I am thinking I
messed up your instructions somewhere....when I go to try the button I get a
dialog box that says:
The expression On Click you entered as the event property setting produced
the following error: Ambiguous name detected: cmdPrint_Click.

 

[Guest]

Allen, I have tried numerous times and I just cant get it to work. Is there
another method to get this to go? Thanks.

 

[Douglas J Steele]

Sounds as though you already had a button named cmdPrint with code
associated with it, or else you've duplicated the code.

Check in your module for two separate declarations of Sub cmdPrint_Click(

 

[Allen Browne]

Did you set the On Click property to:
[Event Procedure]

Then click the Build button (...) beside that.

Once you have the code in the code window, choose Compile on the Debug menu.
It will tell you if there is a problem to fix.

If you are still stuck, tell us about your primary key field:
- name?
- data type (e.g. Autonumber?)

Also the name of your report.

 

[cowpattybill]

Thanks for the Compile tip. I had the same issue and that fixed it for me.