I have a form in my Access 2003 application called 'frmShipment' which is bound to 'tblShipment'. I can print shipment infromation from several different areas in the app, only one of which is a button 'btnPrint' that is in the header of 'frmShipment'.
The shipment prints use 'tblShipment' as their record source.
The problem occurs in this scenario:
The user opens frmShipment and enters some new information. They press 'btnPrint'. Since the underlying report is bound to 'tblShipment' the information that they just entered doesn't appear on the report. How can I make sure that allof the information, including what they just entered is on the report, wihtout makingthem save the record then come back in.
Is there a way to force a 'Save' before the report is invoked?