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. 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
 
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
 
Peter,

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

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

--

peter walker MVP

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

Kevin said:
Peter,

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

Thanks.
Click to expand...
 
Yes, but what if the subform is in datasheet view?



? "Kevin said:
Peter,

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

Thanks.
Click to expand...
 
.....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

Dimitris Nikolakakis said:
Yes, but what if the subform is in datasheet view?
Click to expand...
 
Back
Top