update dataentry through form

[mitraexport03]

Hello sir,
good day
I am beginner to access database , I have created data entry form having add button to add record.
I want to update the record in table as soon as i click add button
so pl. any one can show me the vba code

thanks in advance
ajit vyas

 

[Gasman]

Make the form bound and save yourself a lot of grief.
Else you will need to use an Update query on that Add button.

 

[GPGeorge]

Hello sir,
good day
I am beginner to access database , I have created data entry form having add button to add record.
I want to update the record in table as soon as i click add button
so pl. any one can show me the vba code

thanks in advance
ajit vyas

Because Bound Forms automatically save the current record when you move focus to a different record, there is no need for an additional manual Save for that record.
Your "Add" button does just that, it saves the current record and moves focus to a new record, ready for you to create and save that new one.