P
Peter Marshall
In a form that the user can goto Next or Previous record, how do I prevent
them from going to a New record?
them from going to a New record?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Al Campagna
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."
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."
P
Peter Marshall
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.
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.
R
RonaldoOneNil
In the forms properties, set the allow additions to No
A
Al Campagna
Peter,
What version?
I can't duplicate your problem.
A form, with Allow Additions = No, will not allow access a new record.
So there's something else going on here...
Try this...
Place an unbound text control on the form with a ControlSource of...
=IIf([newrecord],"New","Not New")
Also, what code are you using to open the form?
If you use the acFormAdd, or acFormEdit, you can override the
AllowAdditions.
Try just
DoCmd.OpenForm "YourForm"
to see if that makes any difference.
--
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."
What version?
I can't duplicate your problem.
A form, with Allow Additions = No, will not allow access a new record.
So there's something else going on here...
Try this...
Place an unbound text control on the form with a ControlSource of...
=IIf([newrecord],"New","Not New")
Also, what code are you using to open the form?
If you use the acFormAdd, or acFormEdit, you can override the
AllowAdditions.
Try just
DoCmd.OpenForm "YourForm"
to see if that makes any difference.
--
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."