Macro to Run a Form with parameter query, then execute next macro 1

[jacquid]

Instead of using a parameter query I used a form to gather the critera for a query.

My problem is :
Macro line 1: "OpenFrm" - The macro opens the form and a button on the form opens & executes the append query. No problem here.

Macro Line 2: "OpenQry" - should execute the next query in the sequence. This is where the problems is - the form remains open and this macro line is not executed.

How to I solve this?

 

[LarryDeLaruelle]

If I understand your question correctly, you probably need to add a VB line to the end of the OnClick code:

DoCmd.Close acForm, "frmName"

This will close the form.

Let me know if this helps.

Larry De Laruelle
larry1de@yahoo.com

 

[jacquid]

Thanx it worked like a charm!