Commnad Button on Form

[TotallyConfused]

I have a question regarding how many append forms can I call simultaneously?
I have a form with a command button. When I click on the button I am only
able to call and append 1 query. How can I or can I run 5 append queries at
the same time? If so, How do I do this with out entering 5 command buttons?
Thank you for any information you can provide. Thank you.

 

[Allen Browne]

You can use a macro with RunSQL on several lines, so it executes one after
the other.

IMHO, you would be much better off to use Execute in code, as described in
this article:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

Not only can you avoid the confirmation dialogs while still knowing if a
problem occurs, you can also wrap the entire operation in a transaction (for
an all-or-nothing result.) Details and example in:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...