Form will not allow data entry

  • Thread starter Thread starter mpa.pirate05
  • Start date Start date
M

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!
 
mpa.pirate05 said:
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!
Click to expand...

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
 
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
Click to expand...

Thanks Scott! I will try the subforms route.

Mike
 
Back
Top