Prev: YES/NO FIELD IN COMBOBOX
Next: Table ALIAS of INNER JOINs ?!?!
From: John W. Vinson on 19 Mar 2010 12:56
On Fri, 19 Mar 2010 07:45:01 -0700, JMD.Park
<JMDPark(a)discussions.microsoft.com> wrote:

>is there a way to have a new blank form start after entering last input of
>information? Thanks in advance for the help!

If the "Cycle" property of the form is set to the default "All Records", and
you use the Enter or Tab key on the keyboard to move from control to control
(rather than the mouse), Access will indeed move to a blank new record after
the last control in the form's tab order.

If you're using the mouse exclusively, then Access may not have any way to
know when you're done.
--

John W. Vinson [MVP]
From: JMD.Park on 19 Mar 2010 15:55
Receive error "can't find the object 'DoCmd'"

"KenSheridan via AccessMonster.com" wrote:

> In the AfterUpdate event procedure of the control in question put the
> following code:
>
> DoCmd.GoToRecord acForm, Me.Name, acNewRec
>
> This will take you to a blank new record immediately after entering data in
> the control, whether you've just entered a new record or edited an existing
> one. But bear in mind that a user might not necessarily enter the data in
> the controls in the correct order. An alternative would be to make sure that
> the control is last in the form's tab order, and put the above code in the
> form's AfterUpdate event procedure rather than the control's. This would
> mean that the form would move to a new blank record either after entering
> data in the control, or if after entering data in the control and then moving
> back to another control with the mouse or Shift-Tab, they then save the
> record explicitly or by moving off it with the navigation bar.
>
> Ken Sheridan
> Stafford, England
>
> JMD.Park wrote:
> >Last entered would be enter or tab after last field
> >
> >> If you set the form's property to add new records, and add a <Save> command
> >> button, you should get "a new blank form". If you're asking how to have it
> >[quoted text clipped - 10 lines]
> >>
> >> .
>
> --
> Message posted via http://www.accessmonster.com
>
> .
>
From: JMD.Park on 19 Mar 2010 16:02
I am using tab, and the cycle control is set to all records. Still doesn't
work.

"John W. Vinson" wrote:

> On Fri, 19 Mar 2010 07:45:01 -0700, JMD.Park
> <JMDPark(a)discussions.microsoft.com> wrote:
>
> >is there a way to have a new blank form start after entering last input of
> >information? Thanks in advance for the help!
>
> If the "Cycle" property of the form is set to the default "All Records", and
> you use the Enter or Tab key on the keyboard to move from control to control
> (rather than the mouse), Access will indeed move to a blank new record after
> the last control in the form's tab order.
>
> If you're using the mouse exclusively, then Access may not have any way to
> know when you're done.
> --
>
> John W. Vinson [MVP]
> .
>
From: JMD.Park on 19 Mar 2010 16:55
Is working now, have to tab through buttons. Thanks!

"JMD.Park" wrote:

> I am using tab, and the cycle control is set to all records. Still doesn't
> work.
>
> "John W. Vinson" wrote:
>
> > On Fri, 19 Mar 2010 07:45:01 -0700, JMD.Park
> > <JMDPark(a)discussions.microsoft.com> wrote:
> >
> > >is there a way to have a new blank form start after entering last input of
> > >information? Thanks in advance for the help!
> >
> > If the "Cycle" property of the form is set to the default "All Records", and
> > you use the Enter or Tab key on the keyboard to move from control to control
> > (rather than the mouse), Access will indeed move to a blank new record after
> > the last control in the form's tab order.
> >
> > If you're using the mouse exclusively, then Access may not have any way to
> > know when you're done.
> > --
> >
> > John W. Vinson [MVP]
> > .
> >
From: John W. Vinson on 19 Mar 2010 17:22
On Fri, 19 Mar 2010 13:55:02 -0700, JMD.Park
<JMDPark(a)discussions.microsoft.com> wrote:

>Is working now, have to tab through buttons. Thanks!
>

aha!!!

You can set the Tab Stop proprety of a control to No if you want to avoid this
hassle. On the other hand, it's often helpful to have buttons in the tab
sequence - you can click the button by tabbing to it and pressing the
spacebar, and never need to touch the mouse at all.
--

John W. Vinson [MVP]
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: YES/NO FIELD IN COMBOBOX
Next: Table ALIAS of INNER JOINs ?!?!