Running Code within a Form

[Papa_Don]

Group,

I'm working in Macro that I didn't write. This Macro was written to do run its commands one selection at a time (the selections are made via a drop-down box). I need to modify this to loop these selections so that all will run automatically one after another.

It's easy to read the sequence of events that take place during the run of the routine. However there are a couple of forms the writer created that have "OK" buttons to fire off the next part of the sequence. I need to write the code to use this and, in essence, "click" the "OK" button via the code. However calling that doesn't seem to be the correct way to do this. I've tried

frmFileFilter.cmdOK

to call it. "frmFileFilter" is the name of the form and "cmdOK" is the name of the button. I sure my syntax is incorrect but I can't seem to find what will fire this off. Would any of you know how to do this?

In advance, thanks for your help and wisdom!

Papa Don

 

[CMAnslow]

Hi,

What is the form used for? Is it used to collect information?? If its not needed it would be easier to just not show the form.

 

[Papa_Don]

CMAnslow, the form has some initialization behind it that looks important. Thus is am opening the form. I did try

Application.Run [COLOR=#333333]frmFileFilter.cmdOK[/COLOR]

that seems to let it run. But further into the sequence it errors out for other reasons. When I have time I may post that if I can't get past it.

Thanks for your input.

Don