Hi, I am trying to associate a button in a form with the Access table but i am not able to connect it. But the navigation bar is working fine. How to insert or update a record by clicking a button in the form window.

DoCmd.GoToRecord acForm, "FormName", acNewRec

I think this will work for you, just replace the "FormName" with your forms name. You might want to set focus to the first field after the update though.

hai, thanks for the reply, let me try that now.