If it is a problem on another machine, have you added a line before the insert that displays reccount()?
Something like MESSAGEBOX("The record count is "+str(reccount()))...and then add the same line after...just a temporary thing to help debug...this will verify that INSERT is indeed adding two records (or not)....
Joe
P.S. Have you compiled and executed the EXE on your machine? How many records are added?
>>>>>>>I run this program on c: the user runs on e: when I
>run I do not get this problem, only one record is added.
>user's machine is faster than mine, 200 vs 133 pentium
>could this be a factor? Could user's running on e: be
>a factor? I will try your suggestion, but I don't
>know how effective it will be since I am not experiencing
>the problem in development.
>
>Jim,
>>>One other thing, the record is scattered from a different
>>>database file and inserted into invoices, I don't know if
>>>that has anything to do with this or not. Should I set
>>>up a relation between the two databases? Would it help?
>>>
>>Becky,
>>
>>No on he relation. I would oen the debugger and set a break point on RECCOUNT("Invoices") and run your code. You should breakon the INSERT INTO line, if you then right click the title bar of the debugg window and choose Resume you should NOT break again, if you do you've found the line that';s creating the second record.
Joseph C. Kempel
Systems Analyst/Programmer
JNC