[AccessD] Access problem with tables

I don't know what the relationships are between these tables, but it seems
like, if you base one recordset on a query based on all three tables, you'd
just need one recordset. 

Susan H. 

No, save the first, before you open the second.  And I also close it,
destroy it (set it to nothing) and recreate it if I'm going to reuse it.