Suppressing PgUp/PgDn keys

[giedrius]

Hello,

I was wondering how can I suppress PgUp/PgDn keys in a form event. I want user not to allow to go to any other record except currently displayed in a bound form. Setting form property Cycle to Current Record does not prohibit user from browsing the records using PgUp/PgDn keys.

Thanks for any tips how to do that.

giedrius

 

[spacepro]

Try this.

http://www.mvps.org/access/forms/frm0016.htm

Andy

 

[ghudson]

What if they have a scroll mouse wheel?

Search this forum for the key words "mouse wheel" and the user id "ghudson" and look for the post that I added a modified version of a sample that shows how to disable/enable the mouse wheel when needed. Not my "Mouse Trap" sample for that is for another issue.

HTH

 

[giedrius]

Thank you very much for the solutions.

giedrius

 

[Rich]

Why not open the form with just the one record displayed?