Button actions on form...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msk - 20 May 2008 19:33 GMT

hi there, new to access and have a quick question. I am creating a very
simple data entry form, and have a couple buttons that are included at the
bottom of the form. After entering the data into the textboxes, there is a
SAVE record button and then NEXT record button. Basically, I'm wondering how
you could combine the actions of these two buttons. When the user is done
entering a record, I want to save it and then automatically jump to a new
(blank) record on the data entry form. So I would like to take a 2 step
process (user clicks SAVE, and then clicks NEXT and then starts entering the
data for the new record) and turn it into 1 step. One other thing, how would
you automatically put the focus back on the first textbox when you hit the
SAVE/NEXT Button? Basically, just trying to streamline the data entry
process. Thanks for any help...

Reply to this Message

Al Campagna - 20 May 2008 21:05 GMT

msk,
With one button named cmdNewRecord, and using the OnClick event...

Private Sub cmdNewRecord_Click()
DoCmd.GoToRecord, , acNewRec
End Sub

Whenever you move from record to record,
the record you are leaving is Updated by Access, (if Dirty) so no need to
code for it.

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

> hi there, new to access and have a quick question. I am creating a very
> simple data entry form, and have a couple buttons that are included at the
[quoted text clipped - 12 lines]
> SAVE/NEXT Button? Basically, just trying to streamline the data entry
> process. Thanks for any help...

Reply to this Message

msk - 22 May 2008 16:06 GMT

Thank you for sharing that with me Al, works A-OK.....

> msk,
> With one button named cmdNewRecord, and using the OnClick event...
[quoted text clipped - 23 lines]
> > SAVE/NEXT Button? Basically, just trying to streamline the data entry
> > process. Thanks for any help...

Reply to this Message

Stockwell43 - 21 May 2008 18:08 GMT

Hi msk,

I believe your referring to the Add Record button. Go to your wizard and
click on the button icon to create a new button. When the Command Button
Wizard opens, click on Record Operations on the left and then to the right
you should see Add New Record. Click on that and then click on Next until you
go through the stages and then click Finish.

> hi there, new to access and have a quick question. I am creating a very
> simple data entry form, and have a couple buttons that are included at the
[quoted text clipped - 8 lines]
> SAVE/NEXT Button? Basically, just trying to streamline the data entry
> process. Thanks for any help...

Reply to this Message