Access 2002

  • Thread starter Thread starter Sunita
  • Start date Start date
S

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

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

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.
 
Thank you, this information helped.

Dirk Goldgar said:
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.
Click to expand...
 
Back
Top