Thanks David
>Gaylen,
>
>You have to pull the value to a memvar before you use it in a SQL command. This is because the SQL actually executes outside the form method.
>
>>How do I reference thisform.xxx.value in an update?
>>
>>
>>update tablex set field1 = thisform.xxx.value
>>
>>
>>VFP thinks thisform.xxx.value is an alias. I can assign the variable to a memory value before the insert and use it and it works fine. I've used (thisform.xxx.value) and macro substitution to no avail.