I have a continuous form that is set to allow additions because i need
the user to be able to add new records.
The problem is I need the user to add the new record by using a
command button. By having the form set to allow additions Access
automatically adds another record (unsaved) to the bottom of the list
which might lead the user to jump to that record and begin entering
data, instead of creating a new record with the command button (which
updates some fields behind the scenes).

If i set the Allow Additions to NO then my macro isn't able to create
another record and update the fields as it should.

Is there a way to remove this empty record at the bottom of the list
and still allow the macro to create a new record as it is instructed
to do?

thanks
Steve

On Fri, 3 Jun 2011 14:43:31 -0700 (PDT), "(E-Mail Removed)"
<(E-Mail Removed)> wrote:

>I have a continuous form that is set to allow additions because i need
>the user to be able to add new records.
>The problem is I need the user to add the new record by using a
>command button. By having the form set to allow additions Access
>automatically adds another record (unsaved) to the bottom of the list
>which might lead the user to jump to that record and begin entering
>data, instead of creating a new record with the command button (which
>updates some fields behind the scenes).
>
>If i set the Allow Additions to NO then my macro isn't able to create
>another record and update the fields as it should.
>
>Is there a way to remove this empty record at the bottom of the list
>and still allow the macro to create a new record as it is instructed
>to do?
>
>thanks
>Steve

Why not instead do your "behind the scenes" updating/record creation in the
Form's BeforeInsert event (which fires when the user types the first keystroke
in any new-record field)?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

On Jun 3, 7:20*pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On Fri, 3 Jun 2011 14:43:31 -0700 (PDT), "fish...@hotmail.com"
>
>
>
> <fish...@hotmail.com> wrote:
> >I have a continuous form that is set to allow additions because i need
> >the user to be able to add new records.
> >The problem is I need the user to add the new record by using a
> >command button. By having the form set to allow additions Access
> >automatically adds another record (unsaved) to the bottom of the list
> >which might lead the user to jump to that record and begin entering
> >data, instead of creating a new record with the command button (which
> >updates some fields behind the scenes).
>
> >If i set the Allow Additions to NO then my macro isn't able to create
> >another record and update the fields as it should.
>
> >Is there a way to remove this empty record at the bottom of the list
> >and still allow the macro to create a new record as it is instructed
> >to do?
>
> >thanks
> >Steve
>
> Why not instead do your "behind the scenes" updating/record creation in the
> Form's BeforeInsert event (which fires when the user types the first keystroke
> in any new-record field)?
> --
>
> * * * * * * *John W. Vinson [MVP]
> *Microsoft's replacements for these newsgroups:
> *http://social.msdn.microsoft.com/For...-US/accessdev/
> *http://social.answers.microsoft.com/.../en-US/addbuz/
> *and see alsohttp://www.utteraccess.com

Is there now a way to open a form and have the macro set the "allow
additions" propert to YES then continue with the other activities in
the macro?
that seems to be easier to get my head around.

thanks,
Steve