Force Form Record To Update
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?
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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER