>>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
hi ed...
is that...
thisform.fieldname.controlsource=" "
rob