Locking the scroll wheel

[Timothy Millar]

I have a form that pulls records from a query that will list only one record
but it shows the one record and a blank record. I need to lock the scroll
whell because one of the memo fields will include a time/date stamp. If the
user uses the scroll wheel it will place this time/date stamp in the both
records even though the second one is blank. Any suggestions?

 

[Arvin Meyer [MVP]]

Try this:

http://www.lebans.com/mousewheelonoff.htm

 

[Ron2006]

The blank record most probably is Access saying here is the start of a
new record. (It will not be saved until you change some information in
one of the fields on that record.)

If you go into the data tab of the form properties and turn off the
allow adds property then they will not see the "blank" record (unless
of course you want them to be able to add the record from that form).
You may also want to turn off the allow delete proberty.

Ron