Can I disallow scrolling through records with a mouse?

[Pat]

I am concerned about a user who is editing or completing a form being able to
use their mouse to scroll through other records before they are finished
with the current record. I am worried they will inadvertently change
something in the wrong record.

Record selectors, scroll bars and navigation have been disabled in the form,
but the user can still change records with their mouse.

Is there some way to prevent them from scrolling to another record?

Thanks

 

[Ed Metcalfe]

I am concerned about a user who is editing or completing a form being able
to
use their mouse to scroll through other records before they are finished
with the current record. I am worried they will inadvertently change
something in the wrong record.

Record selectors, scroll bars and navigation have been disabled in the
form,
but the user can still change records with their mouse.

Is there some way to prevent them from scrolling to another record?

Thanks

Pat,

You can, but not with a macro - you need to use VBA.

The following article explains in detail how to do this. It relates to
Access 2000, but it should work in later versions as well:

http://support.microsoft.com/kb/278379

Ed Metcalfe.

 

[Pat]

Thank you!

Pat,

You can, but not with a macro - you need to use VBA.

The following article explains in detail how to do this. It relates to
Access 2000, but it should work in later versions as well:

http://support.microsoft.com/kb/278379

Ed Metcalfe.