continuous form field name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MechEngr - 23 Nov 2006 01:56 GMT

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

Reply to this Message

Ken Snell (MVP) - 23 Nov 2006 03:22 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> 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

Reply to this Message

MechEngr - 23 Nov 2006 15:35 GMT

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.

> 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,
[quoted text clipped - 5 lines]
> >
> > thanks

Reply to this Message

Marshall Barton - 23 Nov 2006 16:53 GMT

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.

Signature

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
[quoted text clipped - 9 lines]
>> > particular record when the user selects one of the field values on the
>> > continuous form?

Reply to this Message

MechEngr - 23 Nov 2006 23:11 GMT

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
[quoted text clipped - 17 lines]
> >> > particular record when the user selects one of the field values on the
> >> > continuous form?

Reply to this Message