>Hello,
>
>We are using Visual FoxPro 5.0 and we are building a framework. For our security form we are using textboxes wich are directly related to the database. To add new records we are using the 'insert'-command instead of the 'append blank'-command. If we add a new record we first delete the textboxes. When we push the 'save'-button the 'insert'-command is being executed and the record will be appended. The problem is that if we don't push the 'save'-button, the current record is changed when the program is reaching the tableupdate(.T.)-command. The question is: Will it be better if we use textboxes wich are not related to the database or can we use textboxes wich are related?
>
>Greetings,
>
>Afier Appelman
>Using the account of Koos Veel

I'm not sure what you mean when you say "delete" the textboxes. If your just hiding the box or erasing the contents? Anyway, if the box has a controlsource that is in the data environment of the form, tableupdate will replace the contents of the bound field in the current record with the value of the textbox, even if the box is hidden or the value is " ". You can use a textbox not bound to a table by simply inserting the value property of the textbox to the desired location. 6 of one, half a dozen of the other I would think. You might want to consider subclassing the wizstyle navigation toolbar.

Eric K.