Help with UPDATE utilizing a working SELECT

[floridagal]

I'm very new to Access 2000. I'm working with 3 tables.

I finally got this sql statment to work:
SELECT [tlkp.Language].[LangID],
[tblRawData].[LangName],
[tblApplication].[AppID]
FROM (tlkpLanguage INNER JOIN tblRawData
ON [tlkpLanguage].[LangName]=[tblRawData].[LangName])
INNER JOIN tblApplication ON [tblRawData].[AppID]=[tblApplication].[AppId]

How can I change it to UPDATE?
I want to update the tblApplication.LangID = tlkpLanguage.LangID using the joins described in the select statement?

There is no LangName field in the tblApplication.
I have tried everything and I keep getting syntax errors.

 

[capsula4]

SELECT [tlkp.Language].[LangID],
[tblRawData].[LangName],
[tblApplication].[AppID]
FROM (tlkpLanguage INNER JOIN tblRawData 
ON [tlkpLanguage].[LangName]=[tblRawData].[LangName])
INNER JOIN tblApplication ON [tblRawData].[AppID]=[tblApplication].[AppId]

I'm also a bit newbie, but I was thinking if don't you have to add
[tblApplication].[AppId] and [tblRawData].[AppID] in the SELECT statement, and also not sure if [tblApplication].[AppId] should be [tblApplication].[AppID]