Thanks I must have been asleeep. I totally missed the fact that I need to do a replace.
>
>luYourValue = Thisform.Control.Value
>REPLACE Field WITH luYouValue IN Table
>
>
>HTH
>
>
>I created a form which does not have any control sources for the fields. I uses optomistic buffereing. I have save button and in it I have lines like
>
>>table.field = thisform.name.value
>
>>I get the error message that "table" is not an object.
>
>>My questions are:
>
>>1. Do I have to assign control sources to the fields?
>>2. Do I need the "tableupdate" command in the click method of my "save" button?
>>23 In the click method of my "Cancel" button do I need to issue the "tablerevert" function before the "thisform.release" command to avoid the message that some fields have been changed message?