When you call a form in add, how to keep it from rolling to new re

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use a menu to open or edit this form. The add, opens it in add, when you
input , my users can use the rollerball and it will go to a new record. How
do I keep it on that record only. I did put vb on after insert allow additons
to false, but then they have to double click to get out. It does not work
when I call up that same form in edit using a filter, it will still roll to
the next record, but only one record.

Oh please, this one is driving me crazy, hope it is a simple thing that i am
missing.
sj
 
1) What do you mean they have to double-clcik to get out?

2) Why do you only want them to add one record? Seems pretty ineficient to
have to click the add button from a menu each time they want to add a new
record.

3) Why not just create code in the after update event to close the form?
 
what happens is, open form to add a record. all is set - but even when they
type in one field and accidently hit the page down or the roller ball on the
mouse it goes to a new record, - how do i keep it on that record and not have
it roll to the next record.
 
That is how a database works. They are telling it to move to a new record,
so that is what it does.

You could help this situation by making some of the fields required. This
would prevent them from moving to a new record without filling in all the
required entries first.
 
Back
Top