Problem using VBA to Insert records

[laffspotpc]

I'm using a form to input data for one table, but I also need that data to go into a different table (for which I'm using VBA). It works for the most part, but every once in a while it doesn't insert the record into the second table.

The code is in the AfterInsert event of the form, and it never gives any error messages. But out of every 25 records it inserts, one or two of them do not make it to the second table (they do go into the main table the form is for).

So I'm wondering if anyone has had a problem like this before and could tell me what I'm doing wrong, or if there might be a better way to do this.

 

[nealmiller1]

In the code behind the event, you could conceivably be using the same recordset object for the two unique tables.
Dim two separate recordset objects, one for each table, and at the end of the routine, set each one to nothing.

HTH,

Neal Miller
Miller Systems, Inc.
708-479-0085 Neal Miller
President
Miller Systems, Inc.
(708) 479-0085