Additions Denied

[Christopher Robin]

It is Friday, so I should probably just go home, but after getting my form
pretty well completed, I thought I would test adding a new record.
Unfortunately, my form is denying me this ability. If I open the linked
table directly, I can add a new record, but not from the form. Here are the
data properties for the form:

Record Source: simple select query
Recordset Type: Dynaset
Fetch Defaults: Yes
Filter: blank
Filter On Load: No
Order By: blank
Order By On Load: Yes
Data Entry: No
Allow Additions: Yes
Allow Deletions: No
Allow Edits: Yes
Allow Filters: Yes
Record Locks: No Locks

Even if I change the Allow Edits property to Yes, the form still denies me
the ability to add new records.

Any insight is greatly appreciated.
TIA,
Chris

 

[Kay]

Is your form bound to a table or query

 

[Kay]

if its bound to a query, open the query up and view it in datasheet view.
See if it lets you add a record there. There is a chance you have some
expressions or relationships that are denying the additions

 

[Christopher Robin]

It's bound to a table, but there is a query in the data source. I'll check
that out, and see if I can a new record.

 

[Christopher Robin]

I discovered my problem. One column was missing from the Query that Access
generated for the form. After adding this column to the query, I'm now able
to add new records. I must have made changes to the underlying table after I
started working on the form.