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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top