Can't Enter Data in Form

[Jeff Miller]

Hello,

I am experiencing some inconsistencies in my ability to enter data in a
form, and I'm hoping that someone can help me understand why this is
the case.

I have an Access file that contains three tables. I have created two
forms.

The first form consists solely of data from one table. In this form, I
can enter (or edit existing) data into the fields.

The second form consists of data from all three tables. While I can
see the data in the forms, I can not enter (or edit existing) data in
the fields.

I created both Forms using the Wizard. Is there a reason why I can't
enter data directly into the one multi-table form?

My ultimate goal is to be able to choose specific fields that can be
edited, with other fields being off limits for editing.

Thanks for your help.

 

[Allen Browne]

Your multi-table form is presumably based on a query.
Open the query directly, and you will see that it is not editable.

There are *many* triggers that cause a query to be read-only, such as
anything that causes aggregation (e.g. DISTINCT predicate or GROUP BY
clause), join types and directions, having a subquery in the field list, and
so on.