I have a form that is an application. I am able to pull an employee up
and then print the application using the following code that is
connected to my Print Application button on the form.

DoCmd.OpenReport"EA Completed
Application",acViewNormal,,"[SocialSecurityNO]=
"""&Me![SocialSecurityNo]&""""

This works great when I have pulled a completed record up. What I need
is for the data entry person to be able to print this application out
before hitting the "Enter" button which writes the record to the table
and advances to a new record. Is there any way to print the
application data out before finalizing the writing to the table?

The data must be in the table before the report can read it, but you can do
that while it is still visible in your form.

Here's how to save and print the entry:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ryker" <rasmith@choctaw.org> wrote in message
news:1137780025.400728.164920@g44g2000cwa.googlegr oups.com...[color=blue]
>I have a form that is an application. I am able to pull an employee up
> and then print the application using the following code that is
> connected to my Print Application button on the form.
>
> DoCmd.OpenReport"EA Completed
> Application",acViewNormal,,"[SocialSecurityNO]=
> """&Me![SocialSecurityNo]&""""
>
> This works great when I have pulled a completed record up. What I need
> is for the data entry person to be able to print this application out
> before hitting the "Enter" button which writes the record to the table
> and advances to a new record. Is there any way to print the
> application data out before finalizing the writing to the table?
>[/color]

That worked...it exactly what I was needing. Thanks!