1. No.
2. In VB, you can show a form modally (formname.show vbmodal). I don't if it exists in Access.


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