continuous form field name

[Guest]

On a continuous form: Is there a way to capture the field name of a
particular record when the user selects one of the field values on the
continuous form?

thanks

 

[Ken Snell \(MVP\)]

When a user makes a record "current" in a continuous forms view, any reading
of the value in a control in that form is for the "current" record. Thus,
you should be able to just read the value that you desire.

 

[Guest]

Ok. Let me focus my question a little bit more. How can I tell which
control the user is reading in that record? I am looking specifically for
with field name of that control. I have 13 active controls in the continuous
form displayed and I need to know which one the user just clicked (or double
clicked) in.

 

[Marshall Barton]

Normally, that's not an issue because the code that's
referring to the control is in one of the control's event
procedures. If you are using a common function for several
controls, then you can refer to the control with the focus
by using Me.ActiveControl.

Also check Help for the ActiveControl and PreviousControl
properties of the Screen object.

 

[Guest]

That was it! Thanks very much.

Normally, that's not an issue because the code that's
referring to the control is in one of the control's event
procedures. If you are using a common function for several
controls, then you can refer to the control with the focus
by using Me.ActiveControl.

Also check Help for the ActiveControl and PreviousControl
properties of the Screen object.
--
Marsh
MVP [MS Access]

Ok. Let me focus my question a little bit more. How can I tell which
control the user is reading in that record? I am looking specifically for
with field name of that control. I have 13 active controls in the continuous
form displayed and I need to know which one the user just clicked (or double
clicked) in.