New record button greyed out

Jacko

[This followup was posted to comp.databases.ms-access and a copy was sent to the cited author.]

I have a jazz records archive database which is supposed to be
updatable via an input form.

Despite setting the form's properties so that it will accept edits,
deletes etc the new record button on the record navigation thingy
stalwartly remains greyed out.

I can add one record at a time by editing the underlying table but
still the form remains "read only".

I am working in admin/owner role and all permissions look ok.

Any clues?

Dave J

Nov 13 '05 #1

Ed Robichaud

The form property that you need is "Allow Additions" set to yes. This will
allow adding new records. This property is different from the "Data Entry"
property, that does not show any existing records, but blanks the form for
adding a new record.
-Ed

"Jacko" <bl*******@hotmail.com> wrote in message
news:MP************************@news.ntlworld.com. ..

[This followup was posted to comp.databases.ms-access and a copy was sent
to the cited author.]

I have a jazz records archive database which is supposed to be
updatable via an input form.

Despite setting the form's properties so that it will accept edits,
deletes etc the new record button on the record navigation thingy
stalwartly remains greyed out.

I can add one record at a time by editing the underlying table but
still the form remains "read only".

I am working in admin/owner role and all permissions look ok.

Any clues?

Dave J

Nov 13 '05 #2

PC Datasheet

What do you mean by "supposed to be updateable"? If the recordsource of your
form is a query, maybe the query is not updateable. In this case you can add
records at the table level but not via the form. Also check the Allow
Additions property under the Data tba of properties.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Jacko" <bl*******@hotmail.com> wrote in message
news:MP************************@news.ntlworld.com. ..

[This followup was posted to comp.databases.ms-access and a copy was sent to the cited author.]
I have a jazz records archive database which is supposed to be
updatable via an input form.

Despite setting the form's properties so that it will accept edits,
deletes etc the new record button on the record navigation thingy
stalwartly remains greyed out.

I can add one record at a time by editing the underlying table but
still the form remains "read only".

I am working in admin/owner role and all permissions look ok.

Any clues?

Dave J

Nov 13 '05 #3