save record doesn't work

[MSD]

I wrote earlier today than I didn't know how to implement a "SAVE RECORD"
command on my form.

I forgot to say that I used the command button wizard to add a SAVE RECORD
button, but it didn't work properly. It keeps saving the same record even
though I have moved to another record in the form. If I use the standard TAB
key to go to the next record, the correct information is saved.

Before I wrote:
I'm using a form to update a record in an underlying table. It works now
using the standard TAB key to go to the next record.

Instead, I want to add a command SAVE ITEM, which would save the item and
put the focus back to the first control on my form. I don't want TAB to
automatically cause the table to be updated.

Any ideas?

Thanks very much,

 

[MacDermott]

If I understand you correctly, it sounds as if you are wanting to move to a
different record in Access, without saving the changes you have made in the
current record.
AFAIK this is not possible.

HTH
- Turtle