467,920 Members | 1,124 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,920 developers. It's quick & easy.

Can't Move Between Records on a Form with the Navigation Buttons

hi
Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm creating a form
using Design View, some fields contain data that are input into the text
boxes while others are from fields from a table. I'm running Access XP,
thanks for any help.
Nov 12 '05 #1
  • viewed: 3040
Share:
3 Replies
hi wrote:
Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm creating a form
using Design View, some fields contain data that are input into the text
boxes while others are from fields from a table. I'm running Access XP,
thanks for any help.


The New record button is enabled only when the source of the form allows
new records. Maybe the form is based on a query that is not updatable.
Maybe you have inadvertedly set the AllowAdditions property of the form
to False (it should be True if you want to insert new records).

--
Bas Cost Budde
http://www.heuveltop.nl/BasCB

Nov 12 '05 #2
On Tue, 03 Feb 2004 04:02:44 GMT, hi <hi@hotmail.com> wrote:

This only happens when the underlying data is not updatable (e.g. the
Form.RecordSource is a Totals query), or when Form.AllowAdditions (and
perhaps Form.AllowUpdates) is False.

-Tom.

Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm creating a form
using Design View, some fields contain data that are input into the text
boxes while others are from fields from a table. I'm running Access XP,
thanks for any help.


Nov 12 '05 #3
hi
In Properties under Data, the "Allow Additions" is set to "Yes". and I
don't see the "Allow Updates" option.
thanks for the replies.
ML
On Tue, 03 Feb 2004 04:02:44 GMT, hi <hi@hotmail.com> wrote:

This only happens when the underlying data is not updatable (e.g. the
Form.RecordSource is a Totals query), or when Form.AllowAdditions (and
perhaps Form.AllowUpdates) is False.

-Tom.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jon Smith via DotNetMonster.com | last post: by
6 posts views Thread by doncee | last post: by
9 posts views Thread by Joshua.Buss | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.