Locked Out Data Entry in Form

[Guest]

Hello,
I've done something somewhere and I don't know what I did. I have five forms
built off five queries, each of which pulls info from the same table. The
five forms reflect the five different geographic regions.

I'm not able to add new records to the forms. What did I do? How can I fix
so new records can be added to each form?

 

[Guest]

If this helps...all I can figure out is that there are two tables joined
together in the query. Why does this prevent me from adding new records if I
pull from a query where two tables share a relationship?

 

[Darrell]

If this helps...all I can figure out is that there are two tables joined
together in the query. Why does this prevent me from adding new records if I
pull from a query where two tables share a relationship?

Jennifer:

This may be too late since the post was from early August, but:
whether or not the query can have records added depends on the structure
of the query. You can tell immediately if the query is updatable by
opening it directly (not through the form) and seeing if you can add a
record there.

Any single-table query is updatable. However, as soon as you add a
second table, it has to be clear to the database which table the record
is being added to. So, the fields where information is being added have
to be unambiguously associated with only one of the tables.

Darrell