Do not allow mouse scroll thru records on a form

R

RobUCSD

Is there another way to keep users from scrolling thru records other than
disabling the mouse scroll funtion? Is there a way to lock the current record
so that you can't go to another record except through a search screen?

Pls help,

Thank , RobUCSD
 
J

John Spencer

Have a one-record recordset with allow additions property of the form set to false.

THen instead of searching the recordset, you retrieve the next single record.
If you want to add records you can use vba to set allow additions to true, go to
a new record, etc. You can disable the allow additions property in the Current
record except when tghe current record is a new record.
 
Top