Selecting row in continuous form (A2003)

[Lyn]

I thought that in an earlier project I was able to click or double-click in
the detail section of a row in a continuous form and use the event to open
a detail form for that row.

However, now a click/double-click in a row's detail section doesn't
generate the relevant click event UNLESS that row is already the current
row (that is, the Record Selector symbol is showing at the left end of the
row). So I guess my thought was wrong.

Of course I could (and can) click in the Record Selector box for the
desired row and then click/double-click the detail section, but that
involves a double action.

I guess what I am asking is: is there a way to select a row and trigger an
event with one mouse action? (It's an efficiency issue.) As far as I can
see, there isn't -- but I was sure I had done it before. Probably
dreaming...

TIA,
Lyn.

[Mike Gramelspacher]

In article <ma************ *************** **@40tude.net>, l.*******@iiNet .net.au
says...

I thought that in an earlier project I was able to click or double-click in
the detail section of a row in a continuous form and use the event to open
a detail form for that row.

However, now a click/double-click in a row's detail section doesn't
generate the relevant click event UNLESS that row is already the current
row (that is, the Record Selector symbol is showing at the left end of the
row). So I guess my thought was wrong.

Of course I could (and can) click in the Record Selector box for the
desired row and then click/double-click the detail section, but that
involves a double action.

I guess what I am asking is: is there a way to select a row and trigger an
event with one mouse action? (It's an efficiency issue.) As far as I can
see, there isn't -- but I was sure I had done it before. Probably
dreaming...

TIA,
Lyn.

Double clicking the record selector on a continuous form causes the form's On
Dbl Click event to fire. Is a double-click one mouse action?

[Lyn]

On Tue, 12 Jun 2007 09:19:49 -0500, Mike Gramelspacher wrote:

Double clicking the record selector on a continuous form causes the form's On
Dbl Click event to fire. Is a double-click one mouse action?

Thanks Mike. Yes, I was counting double-click as a single mouse action.

You have solved part of the problem, at least enough for me to move
forward. I was looking at the wrong double-click event (Detail instead of
Form). The record selector is a rather small target, so I was hoping that
I could arrange it so that a double-click anywhere on the detail line would
allow me to select that row and trigger off it. It seems that that is not
going to work.

However, it does raise another interesting question -- is it possible in
code to force the record selector to a particular row? Or even to
recognise which row was clicked in the Detail area?

Thanks again for your help.

Cheers,
Lyn.

[Larry Linson]

Did you put an event procedure not only in the Detail section's Double-Click
but in each Control's Double-Click? The Detail's Double-Click only fires
when you click outside any of the Controls. (IIRC, you can also cover the
entire Detail Section with a transparent Rectangle and set its Double-Click
event.)

I've done a lot of continuous forms view Forms where you could Double-Click
anywhere on the row.

Larry Linson
Microsoft Access MVP

"Lyn" <l.*******@iiNe t.net.auwrote in message
news:d1******** *************** *****@40tude.ne t...

On Tue, 12 Jun 2007 09:19:49 -0500, Mike Gramelspacher wrote:

>Double clicking the record selector on a continuous form causes the
form's On
Dbl Click event to fire. Is a double-click one mouse action?

Thanks Mike. Yes, I was counting double-click as a single mouse action.

You have solved part of the problem, at least enough for me to move
forward. I was looking at the wrong double-click event (Detail instead of
Form). The record selector is a rather small target, so I was hoping that
I could arrange it so that a double-click anywhere on the detail line
would
allow me to select that row and trigger off it. It seems that that is not
going to work.

However, it does raise another interesting question -- is it possible in
code to force the record selector to a particular row? Or even to
recognise which row was clicked in the Detail area?

Thanks again for your help.

Cheers,
Lyn.

[Lyn]

On Wed, 13 Jun 2007 06:57:47 GMT, Larry Linson wrote:

Did you put an event procedure not only in the Detail section's Double-Click
but in each Control's Double-Click? The Detail's Double-Click only fires
when you click outside any of the Controls. (IIRC, you can also cover the
entire Detail Section with a transparent Rectangle and set its Double-Click
event.)

I've done a lot of continuous forms view Forms where you could Double-Click
anywhere on the row.

Larry,
All of the controls in the Detail section are locked. This seems to make
them invisible to mouse clicks, so double-clicking anywhere in the Detail
section (including the locked controls) will trigger the Detail
double-click event. So I have that covered. I am just trying to find out
if there is any way (other than clicking the Record Selector box) to select
that row and trigger an event at the same time by clicking anywhere on the
desired row. So far, it seems that the answer is no.

Thanks for the response.

Cheers,
Lyn.

[hbinc]

On Jun 13, 2:09 pm, Lyn <l.hanc...@iiNe t.net.auwrote:

On Wed, 13 Jun 2007 06:57:47 GMT, Larry Linson wrote:

Did you put an event procedure not only in the Detail section's Double-Click
but in each Control's Double-Click? The Detail's Double-Click only fires
when you click outside any of the Controls. (IIRC, you can also cover the
entire Detail Section with a transparent Rectangle and set its Double-Click
event.)

I've done a lot of continuous forms view Forms where you could Double-Click
anywhere on the row.

Larry,
All of the controls in the Detail section are locked. This seems to make
them invisible to mouse clicks, so double-clicking anywhere in the Detail
section (including the locked controls) will trigger the Detail
double-click event. So I have that covered. I am just trying to find out
if there is any way (other than clicking the Record Selector box) to select
that row and trigger an event at the same time by clicking anywhere on the
desired row. So far, it seems that the answer is no.

Thanks for the response.

Cheers,
Lyn.

Hi Lyn,

If the controls are locked, but enabled, you can use the OnDoubleClick
event.

HBInc.