"dfg" <EMAIL REMOVED> wrote in message
newsd9wb.479093$pl3.381111@pd7tw3no...
> Small problem:
>
> I have 3 textboxes. The first one accepts integers, the other 2 accept
> strings. They change data in a database, but it doesn't seem to cancel
> the changes if I only change the first textbox. If I change all the
> textboxes it cancels just fine... It's kinda wierd. I've attached the
> files. (I hope that's not a problem...3 files) Can someone tell me
> what's wrong? It's a small program.
>
> Thanks.
>

Looks like they are "linked" to a data source (e.g. the first text box is
***ociated with "adSaleData.SalesPersonID". In this instance, whatever you
type into the box is automatically reflected in the database.

Right now, I can just go in and start typing and the changes will be saved
automatically (which I think is contradictory to your plan since I see a
"save" routine in which you move data into the DB explicitly). If this is
the case, unlinked those boxes and just make them regular text boxes.

You may also want to look into the CancelBatch proc. This will undo both the
cached changes and all pending changes to the current record, e.g:

adSaleData.Recordset.CancelBatch