I have a form which displays information using a single query. This query retrieves data from two tables. Which are linked through a common field. However, I am unable to edit any of the fields within the form. if I make the query look at only one table then I can edit till my hearts content. What am I doing wrong?

Many thanks

Robert Dolphin

anyone?

By editing a field on the form, you are probably trying to change an entry in the table on the 'many' side of a 'many to one' relationship, which cannot be done in Access (neither can you Delete). You many have to think about creating a result table from your two tables, base the form on this, change the form, and hence the result table, and then write an Update query to update the table on the 'many' side.

How do you eat an elephant? Break it up into small chunks. Unfortunately, Access contains many elephants.