How to give a commit statement in VBA?

[jaishu]

Hi,

Do i have to give a commit statement when i update tables in backend(insert, delete,update) from a form, say when user clicks submit, it takes the data in fields and inserts it into the table , but till now i never did that but i could see all data when i queried the table, but i am not sure if that would be right, if i have to give Commit, how do i do that using VBA?

Any help would be appreciated!

Thanks so much in advance!

 

[pbaldy]

If the form is bound to the table, you do not need to do anything. If it's unbound, your process (recordset or SQL) will handle it.