double click on a line

[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

 

[Rick Brandt]

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.

As long as they are locked why do you need them to be disabled? You can place a
transparent button that covers all of the controls, but that will only work in
Continuous view, not Datasheet. It's fairly easy to make a Continuous view that
looks just like a Datasheet though.