Marco Help

[Guest]

Hello...I have a macro that directs a command button to return to the
switchboard. I would like to have the macro not only return to the
switchboard, but actully make a selection on the switchboard. I have been
able to get to the main switchboard by using "SelectObject" and have also
been able to point to the selection I need by using "GoToControl", but I
can't seem to figure out how to make it acutally make the selection (hitting
the "enter" key)....If anyone has any ideas that could make the selection I
would be ever so grateful...

I thank you in advance for any assistance you may be able to provide.

 

[Steve Schapel]

Randy,

I am sorry, I can't figure out what you are trying to do here. Maybe it
would help if you could let us know:
- what sort of control it is that you are setting the focus to, using
the GoToControl action
- what is the meaning of "make a selection" ...an example will
definitely be a good idea
- what is supposed to happen after this "make a selection" thingie
Thanks.

 

[Guest]

Hi Steve...Thanks for your assistance....I basically have a form that has a
command button (labled "Search") on it. I would like the commond button (when
clicked) to direct back to the main menu (or Switchboard) and make a
selection on the menu/switchboard. The selection would be one of the
selections on the main menu called "Search" which would then re-direct to
another menu (the Search Menu). I got as far as getting to the "main menu"
and then the "Search" option but I cannot seem to be able to select the
"Search" option once there. I need it to select this option, as if you were
to actually point at it with the mouse and click or hit enter. Is there a
command that can be used as the Enter key?

 

[Steve Schapel]

Randy,

No, trying to simulate pressing (or hitting, if you will) the Enter key,
is not the way to approach this.

I am sorry to be so thick here. I know it is just a matter of using
different terminology. But I have read through your post over and over,
and I still can't imagine. The parts I am having the most problem with are:
"make a selection" - do you mean a Combobox?
"the 'Search' option" - do you mean an Option Group?
"re-direct to another menu" - do you mean open a Form ?

This would also help... If you were looking at the Main
menu/Switchboard, and actually did press (or hit, if you will) the Enter
key manually, what would actually happen? Ok, how does this happen?...
is there a macro or maybe a VBA procedure that determines what happens next?