Form based on query from 2 tables

I have 2 Tables in MS Access, tbl1 & tbl2, both of which are related through COLUMN ID. I created a query MyQuery joining the 2 tables to get relevant data. I then created a form MyForm, from MyQuery, using the Query Wizard. When I try to edit records in MyForm, it seems like all the textboxes (base on fields from query) are locked. I cant change anything.

Are a solution for this problem? I have read that is imposible to modify data on a form based on join querry between 2 or more tables.

I use Ms Access 2003.


Dan

It's not impossible but it can be difficult. You can usually check if you can add or modify data by looking at the query itself. If you open the query and you can click on the button that has the *> then you'll be able to edit the data in the query.

Typically if the two table have fields of the same name, doing a join between them locks the fields.

There are ways to handle this in code but you can't simply use the fields from the query.