Macro Help

[ToneSta]

Howdy

I have a macro in Access that imports data and runs some update queries. Following that i want to open three different forms sudsequently, i.e next form opens when the previous one is closed. Rather than setup little macros that run on exit from the forms, i want to add instructions to the original macro. I haven't figured how to achive this. Does anyone have any ideas?

Many Thanks

 

[KenReay]

Hi

You just open the forms, one after the other, but open them as modal, then perocessing of the macro will pause after opening form1, until form1 closes, then processing will proceed to open form2 etc

Best advice however is forget macros they are limited old technology, get into VBA



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK