Populate access fields from oracle with script

[mancusoj]

I have oracle tables connected in a access application. I have three fields on one of the forms merchant name, merchant id and pidm. I am trying to have two fields(id and pidm)populated based on a combo box selection(merchant name). The code I have used in an afterupdate procedure is

Private Sub FZTVEND_MERCHANT_NAME_AfterUpdate()
SQL = "Select Saturn_Spriden.spriden_pidm as pidm, saturn_Spriden.spriden_id as id"
FROM "saturn_spriden.SPRIDEN_LAST_NAME = " & FZTVEND_MERCHANT_NAME.Value & "'"
Set R = CurrentDb.OpenRecordset(SQL)
R.MoveFirst
ID = R("ID&quot
PIDM = R("PIDM&quot
Set R = Nothing
End Sub
It will not populate the text boxes.
Any suggestion would be great. Thank you

 

[sem]

Check the value of SQL. It seems to me that it's not evaluated to a valid sql statement. String literals in Oracle should be quoted by single quotes.

Regards, Dima