Run SQL Syntax question

[jimbo62]

I am having trouble referencing a list box value in a sql stsement it tells me my syntax in incorrect. Can anyone help?

DoCmd.RunSQL "UPDATE MainParts SET MainParts.ResourceName = (Forms!Parts.[List34].Column(0))WHERE((Forms!Parts.[Text20].Value=(MainParts.PartNum)))"

Jimbo

 

[jimbo62]

I cured my problem with the list box reference by assigning the value to a text box and using that instead.

If anyone can assist with my original question it would be appreciated.

I must be getting tired...

Thanks

Jimbo

 

[lamarw]

Try putting a space before the WHERE key word.

Lamar

 

[PHV]

Perhaps this ?

DoCmd.RunSQL "UPDATE MainParts SET ResourceName='" & Forms!Parts!List34.Column(0) & "' WHERE PartNum='" & Forms!Parts!Text20 & "'"

If either PartNum or ResourceName is defined as numeric in MainParts then get rid of the corresponding single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886