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.

[Bas Cost Budde]

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

[Tom van Stiphout]

On Tue, 03 Feb 2004 04:02:44 GMT, hi <[e-mail]> 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.

[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 <[e-mail]> 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.