lcSQL = "UPDATE ... " ; + "SET " ; + "NumberColumn = "; + transform(ThisForm.txtBoxNumeric.Value) + ", "; + "CharacterColumn = '" ; + alltrim(ThisForm.txtBoxCharacter.Value) + "' "; + "where PrimaryKeyColumn = " + PKValueIs that what you are doing? Assuming the PKValue is also numeric, what I show above should work. You have to use the ' and " exactly as I have given as well.