By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,291 Members | 1,663 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,291 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.