Re: save record doesn't work

From: MacDermott (macdermott_at_NoSpam.com)
Date: 02/14/04 

Date: Fri, 13 Feb 2004 19:32:56 -0500

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

"MSD" <msdanielson@hotmail.com> wrote in message
news:CKcXb.480321$JQ1.368251@pd7tw1no...
> 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,
>
>