Update from another table

[greg1127]

Hi,
what is the code to update an entry from another table?

I can get the following to work :
DoCmd.RunSQL "UPDATE tblTest SET Password = 'EXPIRED' WHERE ((tblTest.Order) =[Forms]![frm_Expired_Records]![SelectionTxt])"

That works fine, But Trying to insert Details that are already in a table does not work.
I have tried
"Update tblTest SET Password = tblNew.Password... "

How should i code it?

 

[sleipnir214]

You might want to take a look at MySQL's INSERT...SELECT syntax:

http://www.mysql.com/doc/en/INSERT_SELECT.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[greg1127]

The insert select will not work when there is already information in the table, I need the update clause to overwrite the data.