Hello.
I have a macro that opens Form1. Form1's OnLoad event calls Form2. The user selects an item from a combo box on Form2 and clicks OK, the Visible property of Form2 is set to No, and Form1 loads a query based on the criteria selected on Form2. Form1's OnClose event closes Form2.
Everything works great if you select an item and click OK when Form2 loads. The problem is if you close or cancel Form2, you receive an Action Failed error for the macro that originally opened Form1.
Actually, this is the very same method that I use to enter report criteria when generating reports. It works fine with the reports, but does not work with the form. What am I missing?
Help is greatly appreciated.
Stephen
I have a macro that opens Form1. Form1's OnLoad event calls Form2. The user selects an item from a combo box on Form2 and clicks OK, the Visible property of Form2 is set to No, and Form1 loads a query based on the criteria selected on Form2. Form1's OnClose event closes Form2.
Everything works great if you select an item and click OK when Form2 loads. The problem is if you close or cancel Form2, you receive an Action Failed error for the macro that originally opened Form1.
Actually, this is the very same method that I use to enter report criteria when generating reports. It works fine with the reports, but does not work with the form. What am I missing?
Help is greatly appreciated.
Stephen
