Preventing Additional New Records

[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.

 

[John Vinson]

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.

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]

 

[Selv]

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]

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