>>>>>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.