Actually, I saw that solution on another post, but it still allows the form
to go to a new blank record, although it does not allow that record to be
saved. I think I have seen some VBA code that prevents the form from going
to a blank new record.
--
Peter Marshall
Manager Information Services
Ohio Coatings Company
"Al Campagna" wrote in message
...
Peter,
Set the form's Allow Additions to No
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
"Peter Marshall" wrote in message
...
In a form that the user can goto Next or Previous record, how do I
prevent them from going to a New record?
--
Peter Marshall
Manager Information Services
Ohio Coatings Company