Commit updates to current record without changing records

[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!

 

[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

 

[accesswanabe]

Thanks Bonnie...sure appreciate your help!

Yes, you save the record. When you place a button on your form, the button
wizard will give you the option of Record Operation - Save Record.

Bonnie
http://www.dataplus-svc.com


--
Message posted via AccessMonster.com


.

 

[accesswanabe]

Thanks John. All good answers...sure appreciate the help!