Add Records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jessabez - 09 Mar 2007 01:15 GMT

I have a database to which now for some unknown reason (probably really
simple) it no longer allows me to add a new record on the form, only the
table. I have AllowDataEntry set to yes and I dont recall changing any
properties. Is there something I am overlooking or why would it I be unable
to add a new record on the form? Please help.

Reply to this Message

Allen Browne - 09 Mar 2007 01:59 GMT

Is Allow Additions set to Yes?

Make sure the Recordset Type is set to Dynaset.

If you want to see existing records, set Data Entry to No.

You might also check the form's RecordSource is the table (i.e. not a
non-updatable query.)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a database to which now for some unknown reason (probably really
> simple) it no longer allows me to add a new record on the form, only the
> table. I have AllowDataEntry set to yes and I dont recall changing any
> properties. Is there something I am overlooking or why would it I be
> unable
> to add a new record on the form? Please help.

Reply to this Message