Select an entire row in a continuous form

[p4willi]

Hi,
How do I code a double click event to select an entire row displayed on a subform.
My Bound subfrom has 6-8 controls and the user should be able to double click anywhere on a record to bring up another form.
I know Larry Linson did suggest something about creating a rectangle and overlaying these 6-8 controls with it and then using it's double click event..... can someone enumerate this process or suggest something new?

Thanks

[MikeTheBike]

Hi

Write a sub-procedure to open the required form, and call/run this sub-procedure in the double click event of all/each of the controls that represent the record?

MTB

[p4willi]

Hi MTB,
Thanks for the suggestion and it works well. However, is there a way on a continuous form to have these 6-8 controls highlighted in a row (just like in a list box) as if it was one record every time you press the down/up arrow keys or click with a mouse. Then when the double click event is triggered it should open another form?

I can do this with a list box, but because of the limitation to the number of rows the list box object can contain, I am looking to use a continuous form.

Thanks again.

[MikeTheBike]

Hi p4willi

Glad we have something working, but I don't know if you can highlite a confinuous recod on selection (I think not), but is someone does know, perhaps they will enlighten us!?

Question: what is the row limit for a ListBox?

MTB

[p4willi]

MTB,
My list box containing a column count of 10 can only hold 65,536 rows. I've read others have varying numbers.
Will still look forward to someone enlightening me regarding the above issue.

Thanks