Do not allow mouse scroll thru records on a form

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

Guest

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