Copiler Error in Update statement

[aman]

Hi guys

I want to update the rebooker_details field of input table with the following :

rebooker_detail=(old rebooker details)+rebook to loc='" & Me.[Combo33].Value & "' and dept='" & Me.[Combo35].Value & "'
and so I am writing the following update statement but it is giving me compiler error/syntex error.

ssql="update input set rebooker_details=rebooker_details & " " & "rebook to loc=" & '" & Me.[Combo33].Value & "' & "Dept= " & '" & Me.[Combo35].Value & "' "

could anyone please figure it out.
Thanks
AMna

 

[Guus2005]

you have to separate the fields you want to update by a comma and you have to simplify the complete string. To increase readability use variables to store temporary results.

HTH

 

[aman]

my problem is resolved.thanks a lot

cheers