Editing data from 2 different tables

E

Elaine Parlato

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.
 
R

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.
 
E

Elaine Parlato

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
 
R

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

Elaine said:
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.
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
B

BrerGoose

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 ?
 
Top