Buttons

[Kevin]

Hi
I'm new to Access. I would like to add two buttons to my form... 1. SAVE/NEW -so when the user finishes with a record it will save it and clear the form for the next record. 2. SAVE/EXIT -so the user can exit the form when finished all records
I know Access does auto saves and has the new record at the bottom of the form but I want to make it very simple for the user with buttons. Also is there a way to have acces open a form blank instead of the last record
Thanks

 

[Gary Miller]

Kevin,

You are right that Access does the 'auto saves' to the
records. So, you really dont' need the combination of
SAVE/NEW or SAVE/EXIT that you asked for. All you really
need to do is to call for a new record and the one you were
editing or adding will automatically be saved.

DoCmd.GoToRecord ,,acNewRec

For the Exit, all that you need is...

Me.Close

.... if you are only closing the current form.

Regards,

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message

Hi,
I'm new to Access. I would like to add two buttons to my

form... 1. SAVE/NEW -so when the user finishes with a
record it will save it and clear the form for the next
record. 2. SAVE/EXIT -so the user can exit the form when
finished all records.

I know Access does auto saves and has the new record at

the bottom of the form but I want to make it very simple for
the user with buttons. Also is there a way to have acces
open a form blank instead of the last record?