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.