easy VBA / SQL question

[Gates Is Antichrist]

I simply want to set a field in tbl1 to one in tbl2. Would someone please evaluate/test the following?

sSql = "UPDATE tbl1 SET [ShortDesc] = [tbl2].[FL8] from tbl1, tbl2;"
DoCmd.RunSQL sSql

FWIW, there is always exactly one record in tbl1, and exactly one record in tbl2. ("IF" logic will control whether FL8 or another field from tbl2 is today's lucky winner)

Extra credit question: supply the name of Microsoft's d***less P.O.S who devised the insultingly useless dialog 'Syntax error (missing operator) in query expression...'

 

[Norie]

Well I get the same error.

Is there any relationship between the 2 tables?

I create ID's and tried this.

Sub test()
sSql = "UPDATE tbl1 LEFT JOIN tbl2 ON tbl1.tbl1ID = tbl2.tbl2ID SET tbl1.ShortDesc = [FL8];"

DoCmd.RunSQL sSql
End Sub

It seemed to work.

 

[Gates Is Antichrist]

GREAT JOB. That 100% absolutely fixed it. I'm glad you replied. ray: ray:

 

[Norie]

I'm glad you answered.

Now why wouldn't I? :wink: