Why do you like macro substitution so much? :) You should use it only as a last resort because it makes code harder to read and maintain. Not to mention that is slow.

Update userproj ;
  set user_id = thisform.mastertableid ;
  where userid = thisform.txtuserid.value

>Hello Sergey,
>
>I am trying to use the below code to update the records in the table but i am getting the error message saying operator/operand type mismatch.
>
>user_id is a number field in the database.
>
>****************code***********************
>set multilocks on
>use userproj
>= CURSORSETPROP('Buffering', 5, 'userproj')
>
>lccom=[Update userproj set user_id = ]+thisform.mastertableid+;
>[ where userid = ']+thisform.txtuserid.value+[']
>&lccom
>
>?tableupdate(.T.)
>******************End**********************
>
>Sergey Can you please correct the above code if there is anything wrong with it.
>
>Thank you.