How can I update Subform value (Quantity) more than one items in Products table on clicking PrintInvoice (Button) which is on the MainForm
Please see attached record sources snap shots for main & sub form Please help
Record Source.docForm.doc
Novice
Windows 7 32bit 
Access 2007
How can I update Subform value (Quantity) more than one items in Products table on clicking PrintInvoice (Button) which is on the MainForm
Please see attached record sources snap shots for main & sub form Please help
Record Source.docForm.doc
VIP
Windows XP Access 2010 32bit
Might want to review this thread that discusses issue of saving aggregate data.
https://www.accessforums.net/forms/s...tus-30806.html especially from post 16 on.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Requery a subform after updating another table that is linked?
Posting Permissions
Reply With Quote