>Could you give me the first line of code?
>step 1 - you have to set the object's value to a blank

thisform.textbox1.value=""

>setp 2 - when your finished and if the user wants to save his changes,
> you need to insert a new.

insert into your_table (field1) values(thisform.textbox1.value)

>When I have set the objects value to " ", it places a blank in that field
>and in that record the record pointer is on.
>I have gone through the controls changing value, but it changes the values to the fields in the current record.
>
>thanks - Rob

It's because your textbox is bound to a field. Set ControlSource property to "", and when user will enter data, just Value property will be changed