ROW Selection

D

Dave

Access 2003

Is there any way on a Continuous form to make an entire row clickable?


Any help here will be appreciated.

Thanks in advance

dave
 
A

Allen Browne

Make sure the form's Record Selector property is Yes.

You can then select the record by clicking the record selector (at the left
of the row.)
 
D

Dave

Allen,
Thanks for the reply.

I should have been a a little more detailed in my post.
but first - your answer might be acceptable if I can put an event on the
click of the record selector.
Is this possible?

But preferable
I would like the entire row to highlight as you hover over it and be
clickable as if it were one object.
I was just thinking as I was typing this I could cover the row with a
rectangular box and make it clickable (doable?) but the still the issue of
highlighting.

I am assuming this is all probably more advanced coding then I am up to but
I was hoping there might be a way (is it built in to 2007?)

Thanks again

dave
 
D

Dave

I should also mention that clicking on the row (or record selector) needs to
take me to another form based upon the ID of that record.

I can also see the my idea on a rectangular box covering the row was a
stupid idea :(

dave
 
R

Richard Rost

It's not a stupid idea... I used to use a transparent command button over
things to make them clickable like this.

You could also use the form's OnCurrent event to open up another form when
the user clicks on a record. I do this sometimes when I have two forms
side-by-side - on a "list" in a continuous form, and the other a single form
to show that record. It works like a champ. Just put your Openform command
in the OnCurrent event.


I hope this helps you. Let me know if you have any more questions or
comments.

Cordially,

Richard Rost
www.599CD.com
www.AccessLearningZone.com

P.S. Visit my web site and watch my 90-minute ACCESS 101 TUTORIAL for free.
Go to www.599cd.com/Access/NG
 
D

Dave

Allen - thank again. I may just go with the record selector Event

Richard - I "briefly" looked at the command button idea after abbonding the
rectanguler box idea but saw no want to make it transparent.

I will take another look.

Thanks to both of you

dave
 
Top