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