Preventing Additional New Records

  • Thread starter Thread starter Selv
  • Start date Start date
S

Selv

On a form I have set to Data Entry and Additions "Yes", I am having a
problem with users scrolling to a new record, before they have
completed the record they are entering. They are doing this either by
using the scroll wheel on their mouse or page down on their keyboard as
best I can tell.

What is the best way to prevent the addition of more that one record
without unbound controls and using an insert query?

Thanks.
 
On a form I have set to Data Entry and Additions "Yes", I am having a
problem with users scrolling to a new record, before they have
completed the record they are entering.
Click to expand...

What constitutes "completed"? Perhaps you need to put code in the
Form's BeforeUpdate event to prevent leaving the record if it is
incomplete!

If it's pure user error, and there are no (or few) actually required
fields, this is much trickier. You can disable the mousewheel but
there are few ways to prevent users from doing silly things - they're
just too clever!

John W. Vinson[MVP]
 
John said:
What constitutes "completed"? Perhaps you need to put code in the
Form's BeforeUpdate event to prevent leaving the record if it is
incomplete!

If it's pure user error, and there are no (or few) actually required
fields, this is much trickier. You can disable the mousewheel but
there are few ways to prevent users from doing silly things - they're
just too clever!

John W. Vinson[MVP]
Click to expand...

Thanks for the assistance.

I found another post on disable the scroll wheel, which I think will
prevent most if not all of the problem. I'll give it a try.

Again thanks.

Tim Selvidge
 
Back
Top