Editing data from 2 different tables

[Guest]

Hi All,
Could someone please explain to me if it is possible to edit data from 2
different tables that are being showed in the same form?

I created a form which shows fields from 2 different tables and I can not
edit the fields. I would like to be able to change/include data using my form.

Thank you.

 

[ruralguy via AccessMonster.com]

The two tables need to be related in some manner and joined in a query for
the RecordSource of your form.

 

[Guest]

Hello,
Thanks for your answer. However, the ables are related and I have created a
query. I can not even change the data in the query...

What should I do?

Thank you.
Elaine

 

[Douglas J. Steele]

See http://msdn2.microsoft.com/en-us/library/aa198446(office.10).aspx for
some of the reasons your query may not be updatable (and what you can do in
some of the cases)

 

[ruralguy via AccessMonster.com]

Along with Doug's suggestion, here's a link to some thoughts on the topic
from MVP Allen Browne:
http://allenbrowne.com/ser-61.html

Hello,
Thanks for your answer. However, the ables are related and I have created a
query. I can not even change the data in the query...

What should I do?

Thank you.
Elaine

The two tables need to be related in some manner and joined in a query for
the RecordSource of your form.

[quoted text clipped - 7 lines]

 

[Guest]

When you run the query from the DB window, are you able to edit the query
directly ? One obvious thing - are the form properties to AllowEdits set to
no ?