Link to home
Start Free TrialLog in
Avatar of mlcktmguy
mlcktmguyFlag for United States of America

asked on

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?

ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mlcktmguy

ASKER

Perfect