double click on a line

[Dimitris Nikolakakis]

I have a form and a subform

In the subform I have the result of a query. 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

 

[peter walker]

Command buttons can be transparent. See the transparent property on the
format tab. Lay a transparent button over the field you want to activate and
put the code in the dblclick event. When using continuos form you can lay a
button the length and width of the section. Can't miss then<g>

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

 

[Kevin]

Peter,

This is a stroke of genius! I've had several situations
where this solution would have fit the bill.

Thanks.

 

[peter walker]

Not genius...just laziness and experience<g>

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

Peter,

This is a stroke of genius! I've had several situations
where this solution would have fit the bill.

Thanks.

 

[Dimitris Nikolakakis]

Yes, but what if the subform is in datasheet view?

Peter,

This is a stroke of genius! I've had several situations
where this solution would have fit the bill.

Thanks.

 

[peter walker]

.....you write a function to do the job and on the click event of all
controls...
=MyFunction()

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

Yes, but what if the subform is in datasheet view?