Form Control Calling Macro

[pcstru]

Hi pcstru,

Another way is to use an 'On Entry' macro attached to each of the formfields in question, coded along the lines of:

Option Explicit
Public FFName As String
 
Sub GetFFName()
FFName = Selection.FormFields(1).Name
End Sub

Your 'On Exit' macro can then retrieve the value of the 'FFName' variable. If you've got a lot of formfields to make this modification to, you could use a one-off piece of code to modify each formfield's properties ...

Thankyou! You have effectively answered the question I was asking - the "selection" reference is effectively "self" if used with care. I'll watch out for the first control being the default selection - since there should only be the dropdowns active (and calling the proc), then if the global is "" it must be the first control. Thanks again.