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!

[MMcCarthy]

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!

If you are using a DoCmd.RunSQL on an INSERT statement then that will be enough. In other words how are you doing the Insert?

Mary

[jaishu]

yes! i use Docmd. runsql to do all my insert, delete..so u mean, that should be enough???

[MMcCarthy]

yes! i use Docmd. runsql to do all my insert, delete..so u mean, that should be enough???

Yes but without seeing your code I can't confirm anything.