View Full Version : How can I do in the Macro for open Table?


accessman2
09-30-2005, 09:05 AM
Hi
In Macro:

I add "RunCommand" in the Action List;
I add "OpenTable" in the Command box;

so, where do I place the tablename?

Please let me know, thanks.

freakazeud
09-30-2005, 01:15 PM
Hi,
why would you actually want to do this?
Furthermore I suggest moving away from macros. There are very limited and cannot handle error handling.
You could use this in vba (visual basic for applications) code anywhere:

DoCmd.OpenTable "MyNewTable", acViewDesign

This would actually open your table in design view!
HTH
Good luck