Macro to open a toolbar command

[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

 

[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

 

[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.