allow additions confuses user

[fishqqq]

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

 

[John W. Vinson]

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/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[fishqqq]

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/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/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