Can I disallow scrolling through records with a mouse?

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

Guest

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 said:
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
Click to expand...

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.
 
Back
Top