Form question

[Guest]

I am working with Access 2000-2003. I have approximately 255 records in my
table, and on the form, if I use my mouse wheel it moves down through all the
records. Is there some way I can stop that from happening? I would like a
blank form to appear every time I open it so I can input the information, and
if I want to look up a previous record I want to have to put in the NCR # to
bring it up. Eventually I will have a switchboard that takes me to this
input form and it should be blank when it opens and only be accessible to
previous records through input of the number. Thank you in advance for any
help.

Owl Lover

 

[Guest]

mousewheel

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

blank form

In the "on load" event put in a code that will make it go directly to a
newrecord

docmd.gotorecord



To look up a previous record you need to have a text box and a search
button. In the "on click" event of the button put the following code

Me.RecordsetClone.FindFirst "[FIELD1] = " & Me!FIELD2
Me.Bookmark = Me.RecordsetClone.Bookmark

Where FIELD1 is the box you are searching and FIELD2 is the text box in
which you enter the number to search for.

that should work