>Hello, outthere,
>
>
>I have TextBox on a form, which has a Value_assign method. The ControlSource of the TextBox is bount to a field in a table with the same data type. The contents of the Value_Assign method looks like this:
>
>LPARAMETERS tpnValue
>this.value = tpnValue
>
>When the form is initiated, an error message "Record is in use by another user" is issued on the screen. I know the table that has a field bount to the TextBox is not locked by any other form or program. The form's datasession is set to private and the table is opened as shared (not exclusive). When I suspend the program from the error message into the Debug window, the arrow shows me that the error occured when the second line in Value_Assign above is being excuted.
>
>Any help will be appciated, thank you.
>
>Dawa

I'm not sure if this is useful -- and you might already have thought of this but do you know that in a private datasession tables are opened by default as exclusive? If you "set excl off" after the control's have been intiated it's too late the table will be used exclusively. That's why you set those things in the form load method if my memory serves me well. I also don't quite understand the code. I was under the impression that the assign method executes when the value of the property is changed. Clearly in initialization it fires because the form sets the value of the property based on the control source. But then you manually set the value of the property which should cause the assign method to fire indefinitely. Or am I on drugs?