this recordset is not updateable

[Guest]

I built a new MDB access database with a new table "PL-XP-2003", and imported
a table "dbo_tblSoftware" (which is an ODBC table) from a different access
database MDE into my MDB. I created a new query in the MDB to join
dbo_tblSoftware and PL-XP-2003. When I run the query, the data results are
what I anticipated.

SELECT [PL-XP-2003].*, dbo_tblSoftware.*
FROM dbo_tblSoftware INNER JOIN [PL-XP-2003]
ON (dbo_tblSoftware.SWID = [PL-XP-2003].PLID)
AND (dbo_tblSoftware.SWVer = [PL-XP-2003].Vers)
WHERE ((([PL-XP-2003].PLID)=[dbo_tblSoftware.SWID])
AND (([PL-XP-2003].Vers)=[dbo_tblSoftware.SWVer])
AND ((dbo_tblSoftware.PlantID)="PL")
AND ((dbo_tblSoftware.Active)=True));

I now created a form in the MDB using this query as my form's RecordSource.
I only want to display the data (read-only) from the imported
dbo_tblSoftware, and make updateable the data from PL-XP-2003 in my form,
which is built in the MDB. But all the data on the form is non-updateable.
How do I force the ability to update fields that originated from PL-XP-2003?

I am getting the message "this recordset is not updateable." I would have to
believe that what I am doing is a common function... updating one table while
displaying (not updating) info from another table. HELP!

 

[Ray]

Gail

You need to have a main form and a subform. Only one table should be used in
each with the join fields set in the parent child properties of the subform.
The behaviour you are experiencing is normal if I have understood correctly
what you have told us.

Ray