VBA retrieve object name in Access form

R

rugglesredgap

Joined
Apr 7, 2012
Messages
1
Reaction score
0
I'm trying to use vba to retrieve the name of a rectangle object that a user might click on in an Access form. I know how to use "Screen.ActiveObject" to retrieve the name of a text box a user clicks on, but this doesn't seem to work for rectangle objects. There might be 50 rectangles on a given form, and I want to retrieve and store the name of whichever one the user clicks on. Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieve data from Access database and fill data in form 0
VBA - retrieve data on last create named range from previous inserted named range 0
Multi Select List Box in Access 0
MS Access problem 0
Access 2003, Determining which control has been clicked 4
Need vba help..Pls... :( 4
Create a simogram in Excel using rectangles 0
Environ function on vba 3

Top