restricting the mouse tracking button

[Mark]

Hello all,

I have a form in which users fill out to enroll in a
class. After filling in the form they can click a command
button that saves the information (record) in a table and
then the command button's visible property is set to
false. However, if you use the mouse's rolling-button...
(not sure how to refer to the correct name, but it is
between the mouse's right and left click buttons... track-
rolling button???... it allows you to scroll up and down)
after filling out the form and clicking the save record
command button you can use the mouse's tracking-rolling
button to advance to a blank form (next record?) and input
info into the (now) blank fields in the form and those
records are save into the table as well.

My question, can I disable this from happening?

I would like the user to be able to add a new record, but
not be able to advance to add more than more record at a
time.

Thanks for helping me out. As always, there has been
someone with the right answers on this group site.
Thanks!!!!!!

 

[Roxie Aho]

Will a close form command in the Command Button work for
you?
Roxie Aho

 

[Mark]

sure, that would do the trick. Do you know of a way to
lock the form once the user clicks the save command
button, so the information on the screen is like a read-
only environment? Just thought I'd ask. Thanks for your
quick response!!!!

 

[Mark]

Could I use something like "dbReadOnly" as an argument in
the click save command button, so after the record is
saved the form would be locked from adding more records...
but still have the form open? Just a thought. Thanks!!!!

 

[Roxie Aho]

I'm guessing on this one but you can try to set the FORM's
Allow Edits, Additions, Deletions properties to false with
the command button.
Roxie Aho

 

[Jim/Chris]

If you are talking about disabling the mousewheel try
http://www.lebans.com/mousewheelonoff.htm
I have had a little trouble getting it to work for 2000.
Maybe you can

Jim