Why the sequence in my macro was change ?

[budich]

I have a macro which is consist of :
1. setwarnings -------no
2. openform ---------- I open a form to take values
and we use those values as variable
in next parameter queries. We use
those variables in some of next qu
-eries.
3. Openquery -------- query 1
4. Openquery -------- query 2
5. Openquery -------- query 3
6. setwarnings ------ yes

it should be work with this order, but why when I run the macro, it goes directly to action no. 3,4,5 eventhough the form already open but we cannot put some values. I need the to input some value in this form and those values can be used several times in my next queries.
Does anyone know what's wrong with my macro?
Thanks in advance

 

[braindead2]

Sure it is just doing what you tell it to. Open the forms then run the queries. If you want it to wait you need to tell it to wait for you to enter data. I would move the open query actions to another event.

 

[budich]

Hi braindead2,

Yes, your logic is correct! my question next : How to ask the form to wait for me to enter data. What code should I add in the form or should I insert one row in my macro?
Thanks

 

[mfulton]

You should take the queries out of this macro and put a button on the form to click after the data has been entered. You can make another macro that just has the queries in it to be run when the button is clicked. Michelle Fulton

 

[budich]

Dear mhfulton36 ,

Thank you very much for your reply, it seems on a good track!
So I will try to put it the macro in forms event driven.
see you,
Budi