New record - Not "goto new record"

[johndoomed]

Hi,

I use this code to open a form and adding (goto) a new record.

DoCmd.OpenForm ("Oppgave")
DoCmd.GoToRecord , , acNewRec

But, there is a problem with some of the "knockleheads" at my work. The can navigate between the records using the mousewheel. This is actually a problem, and I have to work around it.

Is it posible to only show the new record? (The form can not be an add only form. Only from this button)

 

[Niniel]

You could turn the mousewheel off when the form loads, and enable it again when it is closed, by using the method described here:

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

Or you can open the form as an edit only form just from that button:

DoCmd.OpenForm stDocName, acNormal, , , acFormAdd, acDialog

 

[johndoomed]

Thanks! I think I'll go for the open as edit only. Thanks again!