name of combo box

[1jet]

Hi all,

I have a combo box (cboExample) that runs a function (vbaExampleFunction) at the "after update" event.

Is it possible in the code, to call the NAME of the combo box?
Ie. cboExample.Name

???

I've seen some code where someone was able to get the name of the currently open form (if possible what's the code for that too?)

 

[boblarson]

If the code is on the same form then you can use

Me.Name

to get the name of the form.

My other question would be why would you need the name of the combo if you have already typed it in? Perhaps your example does not reflect the true question. Can you elaborate?

 

[1jet]

Well I have 5 different rows, at the beginning of each row is cboSelectProject1 - 5.
After each combo box, the rest of the row are 5 text boxes.
Each combo box's "after update" executes =vbaFunction() which is to set a default value to all of its corresponding text boxes only for that row.

That's why I need the name of the combobox that executed the function...

Right now I've just done it the long way.
5 individual "after update" functions for each combo box and row.