Koos,

Sounds like you would need to select your table and issue the append blank command - this will blank out all the textbox fields attached to your table in the security form. Then issue tableupdate at the appropiate time to save the buffered data. If no information is to be saved issue the tablerevert.

>Hello,
>
>We are using Visual FoxPro 5.0 and we are making a framework. For our security form we are using the INSERT INTO-command to add records. The Datasource of the textboxes is a table and we use optimistic table buffering. The problem is that if we want to add a record to the table with INSERT INTO we use the values of the textboxes as the source for the fields of the new record, but they already belong to another record (i.e. the record where the record pointer is located just before the insert into command). In FoxPro2.6 we solved this problem by using variables for the textboxes but this would defeat the purpose of the buffers inVisual FoxPro, so we would like to use the new way of doing this (no variables) but how do we add a record with the INSERT INTO command without messing up other records? Thank you for your time.
>
>Greetings,
>
>Afier Appelman
>Using the account of Koos Veel