When do updates on record happen?

  • Thread starter Thread starter personalIT[Really John Sanders]
  • Start date Start date
P

personalIT[Really John Sanders]

Got a problem, wondering if you people can help. (Obviously, otherwise I
wouldn't be posting here, but I needed the introduction.)

When do updates on records take place? I have a form with several
fields. I want to allow users to edit records, changing from 1 to all
fields. I also want to allow them to cancell updating, and return the
record to the values it had before any updating began.

Now, if I have a form with bound text boxes, do these update the record
when the focus leaves that box? I have been working under that
assumption, and creating unbound text boxes, populating on entrance and
saving the values on exit. Or will the record only update when
switching to a different record?

Or, could the rollback command be useful here? Unfortunately my help
file is broken, so I can't get good help there.

Thanks in advance.

If you need to e-mail privately, true[ish] e-address is
personalIT[remove]@juno[remove].com
 
-----Original Message-----
Got a problem, wondering if you people can help. (Obviously, otherwise I
wouldn't be posting here, but I needed the introduction.)

When do updates on records take place? I have a form with several
fields. I want to allow users to edit records, changing from 1 to all
fields. I also want to allow them to cancell updating, and return the
record to the values it had before any updating began.

Now, if I have a form with bound text boxes, do these update the record
when the focus leaves that box? I have been working under that
assumption, and creating unbound text boxes, populating on entrance and
saving the values on exit. Or will the record only update when
switching to a different record?

Or, could the rollback command be useful here? Unfortunately my help
file is broken, so I can't get good help there.

Thanks in advance.

If you need to e-mail privately, true[ish] e-address is
personalIT[remove]@juno[remove].com

.
Click to expand...

No save takes place until the user moves to a new record.
I have a similar type form and use the following code on a
button labeld Exit Without Saving:
If Me.Dirty Then
Click to expand...

DoCmd.RunCommand acCmdUndo
DoCmd.Close acForm, "frm2005NewOrder", acSaveNo
Else
DoCmd.Close
End If
 
Back
Top