Add Records

[Guest]

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.

 

[Allen Browne]

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.)