loading a button caption to a global variable

[texanmike02]

I have a form with up to 100 buttons generated based on a number of conditions. I am trying to pass the caption of a button to a sub so that I can open the correct forms. When a button is clicked how can I read it's caption. Me.caption is reading the form caption.

Thanks,
Mike

[pbaldy]

Me.ButtonName.Caption

[texanmike02]

Me.ButtonName.Caption

Is there a way to tell which button was just clicked?

I want to have one function that opens the correct form instead of creating 30 different functions so

Function openselectedfrm(buttoncaption)
Docmd.open acform, button caption
End function works

[pbaldy]

Check out ActiveControl in VBA help and see if it works for you.

[texanmike02]

Me.ButtonName.Caption

Check out ActiveControl in VBA help and see if it works for you.

Worked like a dream

[pbaldy]

Glad it worked for you. Welcome to the site by the way!

[texanmike02]

Me.ButtonName.Caption

Thanks. Because of work requirements I have been forced to work in excel for most of my projects (turned it into a flat file data repository with Excel as an interface that relies heavily on vba and COBOL emulation I wrote.) but I have successfully made the case to move to access.

Is there any place i can look for theming? I need to get rid of the square that the record selector goes. Turned off the record selector but still have the little square.

Mike

[pbaldy]

I'm not clear on what square you're referring to.