Commit updates to current record without changing records

A

accesswanabe

I have a form that is a contractor's timesheet. I have a button on the form
that launches a series of queries that create invoice items in an invoice
table based on entries in the timesheet. I would like to allow the user to
update the timesheet and use the button so that invoice items change
on-the-fly. Is there a way to commit changes (updates) to the current record
on the timesheet form without having to move between records?

Thanks much in advance!
 
J

John Spencer

Several ways:

Add a button to the form with the following code
If Me.Dirty then Me.Dirty = False

Hold down the shift key and press the enter key in a control that is not a
bound to a MEMO field and has its enter Key Behavior set to something other
than New Line In Field

If the standard menu is showing, select Records: Save Record from the menu

And probably many more.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top