how do I go to a record in a continuous form when clicking on a label

[WindAndWaves]

Hi Gurus

I have a very simple question this time.

I have a continuous form with a textbox (ID number) and a label. The label
has a on_click event: msgbox me.id.value

If I click on the label then I get a message : 1

Now, Imagine I have the cursor on ID = 1 (the first record), then I scroll
down to record 35 (ID =35) and click on the label next to the textbox that
has 35 in it. It may surprise some of you, but I still get a message with
1, not 35.

From a user point of view, this does not make sense.

From developer's point of view it makes some sense, as the label can not be
in focus and therefore, the record selected remains 1 and not 35.

Does anyone know a simple solution to make the form act more intuitive (i.e.
showing a message box with 35, not 1)?

Thank you kindly for any assistance.

- Nicolaas

[Brian]

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Zf******** ************@ne ws.xtra.co.nz.. .

Hi Gurus

I have a very simple question this time.

I have a continuous form with a textbox (ID number) and a label. The label has a on_click event: msgbox me.id.value

If I click on the label then I get a message : 1

Now, Imagine I have the cursor on ID = 1 (the first record), then I scroll
down to record 35 (ID =35) and click on the label next to the textbox that
has 35 in it. It may surprise some of you, but I still get a message with
1, not 35.

From a user point of view, this does not make sense.

From developer's point of view it makes some sense, as the label can not be in focus and therefore, the record selected remains 1 and not 35.

Does anyone know a simple solution to make the form act more intuitive (i.e. showing a message box with 35, not 1)?

Thank you kindly for any assistance.

- Nicolaas

How about putting a transparent command button on top of the label?

[WindAndWaves]

"Brian" <bc**@IHATESPAM clara.co.uk> wrote in message
news:10******** *******@eunomia .uk.clara.net.. .

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Zf******** ************@ne ws.xtra.co.nz.. .

Hi Gurus

I have a very simple question this time.

I have a continuous form with a textbox (ID number) and a label. The

label

has a on_click event: msgbox me.id.value

If I click on the label then I get a message : 1

Now, Imagine I have the cursor on ID = 1 (the first record), then I scroll down to record 35 (ID =35) and click on the label next to the textbox that has 35 in it. It may surprise some of you, but I still get a message with 1, not 35.

From a user point of view, this does not make sense.

From developer's point of view it makes some sense, as the label can not

be

in focus and therefore, the record selected remains 1 and not 35.

Does anyone know a simple solution to make the form act more intuitive

(i.e.

showing a message box with 35, not 1)?

Thank you kindly for any assistance.

- Nicolaas

How about putting a transparent command button on top of the label?

Hi Brian

That is a great idea. Do you reckon that is the only way to do that?

Thanks

Nicolaas

[Brian]

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:0F******** ************@ne ws.xtra.co.nz.. .

"Brian" <bc**@IHATESPAM clara.co.uk> wrote in message
news:10******** *******@eunomia .uk.clara.net.. .

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Zf******** ************@ne ws.xtra.co.nz.. .

Hi Gurus

I have a very simple question this time.

I have a continuous form with a textbox (ID number) and a label. The

label

has a on_click event: msgbox me.id.value

If I click on the label then I get a message : 1

Now, Imagine I have the cursor on ID = 1 (the first record), then I scroll down to record 35 (ID =35) and click on the label next to the textbox that has 35 in it. It may surprise some of you, but I still get a message with 1, not 35.

From a user point of view, this does not make sense.

From developer's point of view it makes some sense, as the label can

not be

in focus and therefore, the record selected remains 1 and not 35.

Does anyone know a simple solution to make the form act more intuitive

(i.e.

showing a message box with 35, not 1)?

Thank you kindly for any assistance.

- Nicolaas

How about putting a transparent command button on top of the label?

Hi Brian

That is a great idea. Do you reckon that is the only way to do that?

Thanks

Nicolaas

Well, you could completely abandon the label and just use a command button,
if you can achieve the appearance you want with the formatting properties of
a command button. I'm sure your assessment of the problem when using a
label is correct, so you need to use a control e.g. a command button that
can receive the focus.

[WindAndWaves]

"Brian" <bc**@IHATESPAM clara.co.uk> wrote in message
news:10******** *******@nnrp-t71-02.news.clara.n et...

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:0F******** ************@ne ws.xtra.co.nz.. .

"Brian" <bc**@IHATESPAM clara.co.uk> wrote in message
news:10******** *******@eunomia .uk.clara.net.. .

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Zf******** ************@ne ws.xtra.co.nz.. .
> Hi Gurus
>
> I have a very simple question this time.
>
> I have a continuous form with a textbox (ID number) and a label. The label
> has a on_click event: msgbox me.id.value
>
> If I click on the label then I get a message : 1
>
> Now, Imagine I have the cursor on ID = 1 (the first record), then I scroll

> down to record 35 (ID =35) and click on the label next to the textbox

that

> has 35 in it. It may surprise some of you, but I still get a

message

with

> 1, not 35.
>
> From a user point of view, this does not make sense.
>
> From developer's point of view it makes some sense, as the label can

not be
> in focus and therefore, the record selected remains 1 and not 35.
>
> Does anyone know a simple solution to make the form act more

intuitive (i.e.
> showing a message box with 35, not 1)?
>
> Thank you kindly for any assistance.
>
> - Nicolaas
>
>
>

How about putting a transparent command button on top of the label?

Hi Brian

That is a great idea. Do you reckon that is the only way to do that?

Thanks

Nicolaas

Well, you could completely abandon the label and just use a command

button, if you can achieve the appearance you want with the formatting properties of a command button. I'm sure your assessment of the problem when using a
label is correct, so you need to use a control e.g. a command button that
can receive the focus.

The problem is that I want to combine the "receive focus" property of the
button with some of the other joys of the label. So I would really prefer a
label who can receive the focus - some way or another...

Cheers

- Nicolaas

[Brian]

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:1%******** ********@news.x tra.co.nz...

"Brian" <bc**@IHATESPAM clara.co.uk> wrote in message
news:10******** *******@nnrp-t71-02.news.clara.n et...

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:0F******** ************@ne ws.xtra.co.nz.. .

"Brian" <bc**@IHATESPAM clara.co.uk> wrote in message
news:10******** *******@eunomia .uk.clara.net.. .
> "WindAndWav es" <ac****@ngaru.c om> wrote in message
> news:Zf******** ************@ne ws.xtra.co.nz.. .
> > Hi Gurus
> >
> > I have a very simple question this time.
> >
> > I have a continuous form with a textbox (ID number) and a label. The > label
> > has a on_click event: msgbox me.id.value
> >
> > If I click on the label then I get a message : 1
> >
> > Now, Imagine I have the cursor on ID = 1 (the first record), then I scroll
> > down to record 35 (ID =35) and click on the label next to the textbox that
> > has 35 in it. It may surprise some of you, but I still get a message with
> > 1, not 35.
> >
> > From a user point of view, this does not make sense.
> >
> > From developer's point of view it makes some sense, as the label

can

not

> be
> > in focus and therefore, the record selected remains 1 and not 35.
> >
> > Does anyone know a simple solution to make the form act more intuitive > (i.e.
> > showing a message box with 35, not 1)?
> >
> > Thank you kindly for any assistance.
> >
> > - Nicolaas
> >
> >
> >
>
> How about putting a transparent command button on top of the label?
>
>

Hi Brian

That is a great idea. Do you reckon that is the only way to do that?

Thanks

Nicolaas
Well, you could completely abandon the label and just use a command

button,

if you can achieve the appearance you want with the formatting

properties of

a command button. I'm sure your assessment of the problem when using a
label is correct, so you need to use a control e.g. a command button

that can receive the focus.

The problem is that I want to combine the "receive focus" property of the
button with some of the other joys of the label. So I would really prefer

a label who can receive the focus - some way or another...

Cheers

- Nicolaas

What joys of a label?! There isn't much that a label can do! Anyhow, if a
label can't receive the focus, then it can't receive the focus - there isn't
a lot anyone can do about that!