Q: How to stop user from 'scrolling' into new record?

[mikeg8]

Possibly a silly question...

Form displayed on screen with command buttons to go to next/previous records, etc (I don't use the built in next/prev buttons).

How can I ensure that the user cannot scroll past the last 'real' record into the 'new', blank record? I don't want some users to be able to add records in this way.

Any ideas would be most appreciated, but please keep any reply simple, as I am!

Mike

 

[BillPower]

Try:
In VBA Code:
Me.AllowAdditions = False

Manually, set the AllowAdditions property of the form to:
No

To turn them on again, True or No respectively.

Bill