Access 2002

[Sunita]

Hi,

I am using Access 2002 on XP Professional platform, I have a problem,
I run an query which joins 5 tables. I use this query to display
fields on a form, all this fields are being displayed read only.

Question -- why they are displayed as read only fields? Is there a
setting or anything which I can set to change it to able to enter a
data or overwrite the displayed information? and update the base table
accordingly?

Sunita

 

[Dave Ruhl]

I've run into the same problem. I believe it has to do
with the tables being linked by Primary Key fields which
can't be updated (like auto-number). My solution was to
use sub-forms for each of the tables (in your case 5).
Sometimes I had to use a sub-form withing a sub-form.

 

[Dirk Goldgar]

Hi,

I am using Access 2002 on XP Professional platform, I have a problem,
I run an query which joins 5 tables. I use this query to display
fields on a form, all this fields are being displayed read only.

Question -- why they are displayed as read only fields? Is there a
setting or anything which I can set to change it to able to enter a
data or overwrite the displayed information? and update the base table
accordingly?

Sunita

See the help topic, "When can I update data from a query?" It will
probably tell you what's making your query nonupdatable, and give
suggestions for how to fix it.

 

[John Vinson]

Hi,

I am using Access 2002 on XP Professional platform, I have a problem,
I run an query which joins 5 tables. I use this query to display
fields on a form, all this fields are being displayed read only.

Many queries are not updateable. A five-table query is VERY likely to
be non-updateable; typically one would use a Form for the "one" side
table with one or more Subforms for the "many" side.

 

[Sunita]

Thank you, this information helped.

See the help topic, "When can I update data from a query?" It will
probably tell you what's making your query nonupdatable, and give
suggestions for how to fix it.