>I don't know where my head is today. Substitute the aforementioned code with:
>
>
>*** Form.Init
>SELECT table
>IF EOF('table') AND RECCOUNT('table')=0
> INSERT INTO table (field,field2) VALUES (value,value2)
> THIS.Refresh()
>ENDIF
>
>
>Sorry for the omission.

Thanks to all who replied.

John,
Thanks for the help. I did away with the bound field and am using a lookup function in the form refresh and updating the value. If the lookup table is at eof() then I set the value to spaces and if the user saves it I write the value back to the table.