How can print data from without closing the form.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SQUAREHEAD - 11 Mar 2005 09:21 GMT

I have create a form for inputing data and within that form I have a button
for printing a sheet which details the input data. When I select "print" the
input data doesn't appear in the respective fields. Close the record and go
back in and print its ok. How can I commit the data to the table without
closing the form

Reply to this Message

Allen Browne - 11 Mar 2005 09:26 GMT

Your button needs to save the record before trying to print it.

Try adding:
RunCommand acCmdSaveRecord

For more detail, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Signature

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.

>I have create a form for inputing data and within that form I have a
>button
[quoted text clipped - 4 lines]
> back in and print its ok. How can I commit the data to the table without
> closing the form

Reply to this Message