Using mouse scroll wheel to create new records

[jturn00 via AccessMonster.com]

I am finally working out the kinks in my DB. I have a button that creates a
new record in a subform when the user selects it from a list in a main form.
It keeps track of the main form id (which is stored in a variable on the
subform as subpoenaID.) If i create a new form using this button, then my
applications keeps track of the subpeonaID.

BUT if I use the scroll when to create a new record, it loses track of the
subpoenaID. (I don't allow this field to be blank so the user gets an error)
I don't want to disable the mousewheel. Is there an easy way (or where is the
control) for setting the subpoenaID for the newly created record when the
mouse scroll wheel is used?

 

[Guest]

You could set the value of the control in the form's Current Event:

If Me.NewRecord then
Me.SomeControl.DefaultValue = subpoenaID
End If