disabling autosaving in bound text boxes

[Haggy187]

Heres the situation. I have a giant 1 table database.

I really don't care if I use bound or unbound textboxes, although bound would be easier.

I would like to make it so when a user chances a textfield it doesn't automatically erase and update the previous data in the field.

Additionaly, I'd like to make it so if a change has been made, the user must save or cancel changes before they move on to the next record.

Also, can someone please explain to me what the save command is for in access since the data is automatically updated with bound textboxes; and if they are unbound the save button doesn't know what to save them to... Your responses are much appreciated. I'm stuck.

 

[Haggy187]

I know I can change Cycle to Current Record and they may work.

Can someone show me what the code would look like with unbound text boxes. Table1, Field1, Field2, ubText1, ubText2.

 

[Remou]

You can get a record using ADO or DAO and then write the data to unbound textboxes. When the user chooses to save, you can write the data back to the database.

 

[Haggy187]

Can you be more specific... also I know I right code to do it using recordset.update and stuff but I don't know what exactly it looks like; the actual code that is.

 

[Remou]

I am not sure that you are ready for this project. There is a good deal of code involved in my suggestion, which may take some time if you are not used to it. Here are some sites that you may wish to look at:

http://allenbrowne.com/ser-29.html

http://www.tek-tips.com/viewthread.cfm?qid=1064629&page=1

Do you know you can use undo if the user has not saved a record by moving away from it or by choosing save?