Hi!
What version of VFP you use??? I ried this in VFP6 and Value_Assign is NOT fired during refreshing no matter what I do. It seems during refreshing you have some program that assign value to teh Value property. Just pu Set Step On (breakpoint) in the Value_Assign method code and check in Call Stack debugger window where from this method is called and how.
>Hi
>
>In the Value_Assign method of a data bound control the line:
>
>
>This.Value=eNewVal
>
>
>triggers a write to the table which makes sense when you change the value. However when bound to a table field, it also triggers a write to the table when the control is refreshed with new data from a table. So you have the odd situation where the control is refreshing itself with new data from a table and that triggers a redundant write back to the table even though no data has been changed.
>
>Lets assume we have a grid and a combobox on a form. The combobox is bound to a field in the same table that the grid is bound to. Let's assume for some reason that the combobox has a Value_Assign method. Every time you move to a new record in the grid and refresh the combobox the Value_Assign triggers a write back to the table.
>
>Is this the designed behaviour? It would have been nice if the Value_Assign was still accessed in the above secnario but the redundant write back to the file did not occur. In my opinion for what ever it is worth is that the write back to the table should occur everytime the value is changed but not when the value is just being read from the table.
>
>Simon White
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.