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
>
>.

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

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