I've tried this and when I hit the Print Record button, VB opens up and there is a criteria mismatch on the DoCmd.OpenReport line. It did work the very first time I tried it though, but when I closed the form and reopened it, I began to get the error message.
--
Melissa


"Eric Butts [MSFT]" wrote:

Hi,

Take a look at:

ACC2000: How to Print a Single Record from a Form in a Report (209560)
http://support.microsoft.com/default...B;EN-US;209560

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Print Current Record Only
| thread-index: AcRuc1KlNT4NFs3RQR6/wDMFKxTQSQ==
| X-WBNR-Posting-Host: 128.210.148.129
| From: =?Utf-8?B?TWVsaXNzYSBMYW1iaW5v?=

| Subject: Print Current Record Only
| Date: Tue, 20 Jul 2004 09:05:06 -0700
| Lines: 7
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.gettingstarted
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.gettingstarted:152518
| X-Tomcat-NG: microsoft.public.access.gettingstarted
|
| This is from a previous problem. When a user fills out a request form if
the need by date is less than 2 weeks ahead of the submitted date a message
box pops up telling the user they must either change the date they need it
or print the request and submit it to their director for approval.
|
| When I click print button on the message box, it prints all the other
records except the record user is trying to submit.
|
| How do I get it to print just the current record? Another problem also
is that because you can not fill out the rest of the form without a date, I
think that when the current record is printed it will not be completely
filled out. How would I go about fixing that as well.
|
| Thanks so much any and all help is appreciated.
|