|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 22nd, 2006, 04:17 AM
posted to microsoft.public.access.reports
|
|||
|
|||
Print Invoice from Form
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 
|
|
#2
January 22nd, 2006, 05:04 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Print Invoice from Form
One method is to add this line prior to opening your report:
DoCmd.RunCommand acCmdSaveRecord -- Duane Hookom MS Access MVP -- "Roger Bell" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
| Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
| Need to clear controls of Filter form | Jan Il | Using Forms | 2 | November 28th, 2004 02:04 PM |
| Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
| How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Linear Mode
