Hi. I have a couple of questions
First is about the select queries in visual basic for applications in Access.
Is there any way to use a query result such as recordset from one select statement in another.
For Example:

Dim db as database, rs1, rs2 as recordset

Set db = Currentdb()
Set rs1 = db.OpenRecordset("Select * from customer")
Set rs2 = db.OpenRecordSet("Select * from invoices Inner Join rs1 on in_id = em_id")

Is this possible in Visual Basic? I know it can be done very easily if a saved query exists is the
Access Database, but can the OpenRecordset method actually use the recordsets that were created on
the fly?

Second question:
How to suspend execution of code until a certain form is closed.
For example a form is open with a docmd.openform, the form is a modal form. I do not want the
execution to continue after the form object is created, but only when it is closed. I thought that
Modal property set to true would do that, but it didn't
Any help is appreciated.