Form will not allow data entry

[mpa.pirate05]

Hey everyone. I have researched this topic in some other threads, but
I still cannot figure out how to solve the problem.

I have a query that has 5 tables involved (they are linked
sequentially using each table's primary key field). I use a combo box
to select a specific name for which I want the query to pull data on.
The form that opens up displays the data, but I cannot edit any of the
fields that I want to edit. None of the fields I want to edit are
locked, and all are set to allow data entry. I have seen some posts
about the multiple tables possibly being an issue, but I am pretty
sure I need all of the tables in order for the query to work properly.
I have even used the form wizard function and that did not work. Does
anyone have any ideas?

Thanks!

 

[Scottgem (MVP)]

Hey everyone. I have researched this topic in some other threads, but
I still cannot figure out how to solve the problem.

I have a query that has 5 tables involved (they are linked
sequentially using each table's primary key field). I use a combo box
to select a specific name for which I want the query to pull data on.
The form that opens up displays the data, but I cannot edit any of the
fields that I want to edit. None of the fields I want to edit are
locked, and all are set to allow data entry. I have seen some posts
about the multiple tables possibly being an issue, but I am pretty
sure I need all of the tables in order for the query to work properly.
I have even used the form wizard function and that did not work. Does
anyone have any ideas?

Thanks!

A multi-table query is often uneditable. I do not recommend using one as
the Recordsource of a form, especially one meant for data entry. If you
need to view and edit table from multiple tables, use subforms on your
main form.

Hope this helps,
Scott<>
Microsoft Access MVP 2007

 

[Linq Adams via AccessMonster.com]

From Allen Browne, reasons queries are read-only:

http://allenbrowne.com/ser-61.html

 

[mpa.pirate05]

A multi-table query is often uneditable. I do not recommend using one as
the Recordsource of a form, especially one meant for data entry. If you
need to view and edit table from multiple tables, use subforms on your
main form.

Hope this helps,
Scott<>
Microsoft Access MVP 2007

Thanks Scott! I will try the subforms route.

Mike