Macro to open a toolbar command

J

JimAA

I would like to open the "File...Get External Data...Import..." toolbar
commands with one click on a command button in a form. How do I create a
macro to do that?
Thanks,
JimAA
 
S

Stephen English

Jim
This is what you need I think. Just put it in the click event of the
button on your form
DoCmd.RunCommand acCmdImport
REgards
Stephen
 
S

Steve Schapel

Jim,

Use the RunCommand action in your macro, and in the Command argument
enter Import. Save this macro, and assign on the Click event of your
command button.
 
Top