which button was clicked?

[tgriffin]

Im trying to simplify my code on a form. I have a series of command buttons, each of which go to different forms. I want to write code to check which button was last clicked and based on that value, go to a certain form. I guess I would use a Select Case statement?

I would also like to pass the parameter throughout the whole time the user is logged on if possible.

Any direction would be great!!
TIA
tgriffin

 

[Lightning]

Since only one button can be the last button clicked, could you use an Option Group for this? Then open your form based on the option group value.

HTH

Lightning

 

[MichaelRed]

Screen.PreviousControl gives access to the various properties, including the name (and for command buttons, the "Caption&quot. But this doesn't really simplify the process. You would still need the select case structure. Ssince you need that anyway, use the command buttons ..._OnClick event to just send a parameter to your 'master-routine'. The Parameter/message could be the comand button's name or caption or the name of the routine you want to execute ...


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[ScottCybak]

If you want to track, over a period of time.. doing things between button clicks field tabs, entry etc.., the simplest way would probably be to define a form level or a module level variable to track it..

so, when you click a button, it changes the variable after you use it's value.

HTH Scott Cybak
scott@athree.com