ROW Selection

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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.)
 
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
 
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
 
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
 
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
 
Back
Top