macro to handle 2 actions at once

[kevin_vdb]

I made a form where I enter new products and info about it.
I made another form where I enter the place where the product must be stored. Each form has it's own table.
The two tables are connected with an update query, to copy the number and the name of the product from the product table into the storage table.

I can use a click box to run the update query from the new products form.
I also can open the form storage from the form new products, in a way that the storage form shows me the just added new product.

The problem is:
When I try both at once in a macro, It won't jump to the specific record.

Anyone an idea?

Kevin

 

[FoFa]

Some times it is a timing thing. I usually create a function that contains a DoEvents command. Then call the function inbetween the two macros. Some times that works just fine.