Did you add the extra comma? Does the field name in your
code ([CustomerID] in the example) match your primary key
field exactly?
-----Original Message-----
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.aspx?scid=KB;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/se...ulletins/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: 4307D35F-2707-4887-9436-

| 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!
TK2MSFTNGXA03.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.
|


.