double click on a line

  • Thread starter Thread starter Dimitris Nikolakakis
  • Start date Start date
D

Dimitris Nikolakakis

I have a form and a subform

In the subform I have the result of a query in datasheet view. All fields of
line are

Enabled:No
Locked:Yes

I want to double click on a line and open a form to show the specified
record based on a field of the line (OrderID)

I can do it if I enable the field and OnDoubleClick write the code, but I
cannot do it if I make all fields not enabled.

thanks
 
You could place a label over the area. Since everything is disabled and locked anyway, you
can't click into the controls. Set the background and boarder of the label to transparent
so it isn't seen, then use the OnClick event of the label. You will probably need to put a
space character (or something else that won't be seen) in the label when you create it so
that it will stay on the form.
 
How about just inserting a transparent command button over
the area (same idea as a transparent label, except that
you don't have to worry about the space character, etc.)
-----Original Message-----
You could place a label over the area. Since everything
Click to expand...
is disabled and locked anyway, you
can't click into the controls. Set the background and
Click to expand...
boarder of the label to transparent
so it isn't seen, then use the OnClick event of the
Click to expand...
label. You will probably need to put a
space character (or something else that won't be seen) in
Click to expand...
the label when you create it so
 
Back
Top