Click any field in datasheet view

[Guest]

Hi,

I have a form (which is/will be used as a subform), that when I use the
double click event on any one field does exactly what it should, open a
document on my server. As this is form is viewed as a datasheet, I would
like my user to be able to double click any field in the record (i.e.
anywhere on the row) and peform this same action. Is there an easier way to
do this aside from setting the double click event for each an every field of
the record? I tried using the double click event of the form, but then you
have to select the record by double clicking on the far left, where the
little record indicator (i.e the arrow) is; also not ideal.

Thanks in advance.

 

[Rick Brandt]

Hi,

I have a form (which is/will be used as a subform), that when I use
the double click event on any one field does exactly what it should,
open a document on my server. As this is form is viewed as a
datasheet, I would like my user to be able to double click any field
in the record (i.e. anywhere on the row) and peform this same action.
Is there an easier way to do this aside from setting the double click
event for each an every field of the record? I tried using the
double click event of the form, but then you have to select the
record by double clicking on the far left, where the little record
indicator (i.e the arrow) is; also not ideal.

Thanks in advance.

If you make your code a function then you only need to write it once and in the
DoubleClick event of each control you jusy put...

=FunctionName()

You can even hold the control key while selecting all the desired controls and
only enter that one time to apply it to all controls at once.

 

[Guest]

Thanks Rick,

In my case, its only one line of code Application.FollowHyperlink . . . so
there's no real advantage, and unless there's a way to do a 'record event' I
will agree that this is the best solution.

 

[mandyc73]

I know this is old, but it popped up in my search for an answer to the same question.
I thought my solution might be suitable for some people.
I changed my form to Continuous forms view and then added a button to the "front" of the row which opens the report for that record.