Syntax for getting subform field's name

J

Josh Nikle

I have a subform that is in Datasheet View. When I click on certain
fields, a popup form is opened that gets a couple variables passed to
it from the field that I clicked on: the field's name and value.
However, when I click on the field, Me.ActiveControl.Name gives me the
name of the subform's table's ID field instead of the field I actually
clicked, and hense I pass the wrong value to my popup.

What's the syntax then to get the chosen field's name? Thanks in
advance.

-Josh
 
Top