OK, Can I pause the macro or split to parts?

[Rich_Lovina]

Still new,but its working. What is the best way, when running some 45 queries where in when new tables are pasted, together with a linked SubDatasheet, I then want to pause the macro to do some editing, and then return to the macro when I close that table.

The only apparent way is to split the macro on a form and use command buttons for different macro stages. i.e. split macro into parts. Is that correct?

 

[llkhoutx]

Do it in VBA code. Run one set of code or a macro, then on some event run another set of code or another macro.

 

[Rich_Lovina]

Thanks, its basically working quite well now with macro by stages and a master Form of command buttons, each reminding me what I have to do when one of many tables opens.

What I was after is:

With a table open, and editing done is there any way to set an event, "On closing table, return to Command form", or "Go to Macro 3, etc"
Any other ideas folks?

 

[Alexandre]

I believe you are not really talking about a table, but but a form in datasheet view? Then you can use the On_nload property/ event to trigger the macro you want.

Alex

PS. Yes, re-reading your post, I see it is a form datasheet.

[This message has been edited by Alexandre (edited 10-19-2001).]