Mouse Scroll / Records Data Entry

[ilikebirds]

Access 2003:

I notice that on a form there is a menu for RECORDS - Data Entry.
What occurs here is when data is updated and the option is selected It enters the data into the table and starts the form back at 1.

This would help in the mouse scroll case where users enter data and can still scroll through the records

Would it be wise to place an OnEnter event at the last record to Run this Alt+R+D, so Data is entered and the form is back at 1?

[missinglinq]

The OnEnter event occurs when you actually enter a textbox or cbo on a record; there is no OnEnter event, per se, for a record. You wouldn't really want to go back to Record one anytime you had to enter a given field on a the last record, would you? You could simply place a button on your form and either place the code

Me.Requery

behind the button, or even simpler, when the Command Button Wizard comes up, select Record Navigation (which should be up by default) then select Go to First Record. This would also be useful for returning to the first record at times other than when entering a new record,

You could also place the Me.Requery code behind a Save button if you have one (after you've saved the record, of course, or behind a number of other events.

Linq ;0)>

[ilikebirds]

Sorry, I think I expressed myself wrong.

The menu option Records - Data Entry adds all the data from the form into the table and resets itself.

Without selecting that option... it adds data to the table then becomes Record 2.
At this point you can inadvertently mouse scroll through the records.

So I was wondering how to always enter data using the Records - Data Entry option to prevent mouse scroll.