updating and saving and clearing out all the fields in a form

[marklove]

hi good day!!




i'm having a problem in my survey program that it doesn't updating my table when i tried to click my submit button. I used the wizard to create a command button that will save my data to another table but my table is not updating? I'm new to ACCESS and i want to have a command button that will saves and update my table and clears out the field when if you click that command...


any suggestion and help will be appreciated

[June7]

That code commits the record to the table the form is bound to, not to another table. It works.

What you are probably doing is editing the same record and overwriting data. If you want to enter a new record must go to a new record row. This can be done with the intrinsic navigation bar at bottom of form.

A record is committed to table when form closes, move to another record, or run code. Your button runs code but since the form always opens to first record in table, you are just editing the same record over and over.