Hi Mary-Ann,
There is nothing intrinsically wrong with what you are trying to do. Do you have any idea which table the error is referring to? There are many reasons this may be happening. One way this can happen is if you are using optimistic table buffering and adding rows and then, somewhere in the code, using GO nREc where nRec is RECNO(). RECNO()s are negative in appended records in this situation and when saved, become positive record numbers.
>Get this error when the project is run for the first time. I 'Suspend' it to find it's on the line that reads "Thisform.Refresh()" which is in the gotfocus for the main screen. I have this there because a few screens into it, the user can add to the opening screen's pick lists. (I want the pick lists updated when the user gets back to the main screen). What is the better way to do this?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05