Print Invoice from Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Bell - 22 Jan 2006 04:17 GMT

I have created a Control to Print the current record as an Invoice. This
works fine, but when a new record is added and you go direct to Print
Invoice, The details are missing and I suspect this is because the new record
has not been saved.
Is there a way you can write some code into the "On Click" event procedure
so that the new record will save when you click the Print Invoice control?
Thanks for any help

Reply to this Message

Duane Hookom - 22 Jan 2006 05:04 GMT

One method is to add this line prior to opening your report:
DoCmd.RunCommand acCmdSaveRecord

Signature

Duane Hookom
MS Access MVP
--

>I have created a Control to Print the current record as an Invoice. This
> works fine, but when a new record is added and you go direct to Print
[quoted text clipped - 4 lines]
> so that the new record will save when you click the Print Invoice control?
> Thanks for any help

Reply to this Message