Form based on query from 2 tables

[dand_dd]

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

[Oorang]

Hi Dan! I suspect this is because your underlying query is not updateable. It took me a littledigging to find this answer so I will post it here (http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051880011033) (See the bottom section "Data can't be updated")