If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record Update Behavior
Hello,
I am creating a user interface project for data to be updated/inserted into some SQL Server tables. My question has to do with how Access 2003 forms handle updating records. Basically, when using the form, I change a value of a field and go to the next field to edit. As soon as I take the focus off of the field I am editing, it saves the record in the database. I do not want the field to be saved until the Save button is clicked. So if someone was to close the form, the record will revert back to what it was previously. Can anyone please explain how to make this behavior happen? Cheers! Jordan |
#2
|
|||
|
|||
Record Update Behavior
If anyone runs into this, I found that Me.undo will take this behavior away.
"Jordan C. Schroeder" wrote: Hello, I am creating a user interface project for data to be updated/inserted into some SQL Server tables. My question has to do with how Access 2003 forms handle updating records. Basically, when using the form, I change a value of a field and go to the next field to edit. As soon as I take the focus off of the field I am editing, it saves the record in the database. I do not want the field to be saved until the Save button is clicked. So if someone was to close the form, the record will revert back to what it was previously. Can anyone please explain how to make this behavior happen? Cheers! Jordan |
Thread Tools | |
Display Modes | |
|
|