From: Peter Marshall on
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


From: Al Campagna on
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" <peter.marshall(a)ohiocoatingscompany.com> wrote in message
news:usLa4L2yKHA.5360(a)TK2MSFTNGP06.phx.gbl...
> 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
>


From: Peter Marshall on
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" <newsgroups(a)comcast.net> wrote in message
news:e51zra2yKHA.2552(a)TK2MSFTNGP04.phx.gbl...
> 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" <peter.marshall(a)ohiocoatingscompany.com> wrote in message
> news:usLa4L2yKHA.5360(a)TK2MSFTNGP06.phx.gbl...
>> 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
>>
>
>


From: RonaldoOneNil on
In the forms properties, set the allow additions to No

"Peter Marshall" wrote:

> 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
>
>
> .
>
From: Al Campagna on
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."



"Peter Marshall" <peter.marshall(a)ohiocoatingscompany.com> wrote in message
news:eu04ki2yKHA.5132(a)TK2MSFTNGP05.phx.gbl...
> 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" <newsgroups(a)comcast.net> wrote in message
> news:e51zra2yKHA.2552(a)TK2MSFTNGP04.phx.gbl...
>> 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" <peter.marshall(a)ohiocoatingscompany.com> wrote in
>> message news:usLa4L2yKHA.5360(a)TK2MSFTNGP06.phx.gbl...
>>> 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
>>>
>>
>>
>
>