Can't Enter Data in Form

  • Thread starter Thread starter Jeff Miller
  • Start date Start date
J

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.
 
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.
 
Back
Top