Help with DOUBLE CLICK event on a subform

  • Thread starter Thread starter David C. Holley
  • Start date Start date
D

David C. Holley

Here's the deal, I have a main form with a subform. The fields in the
subform are locked down - TabStop = No; Locked = True. When I double
click on a specific record, I want a form to open that displays the
detail for the record.

***I have the code in place to open the form on double-click.***

***The problem that I'm having is that when the mouse is double-clicked
on top of a 2nd, 3rd, 4th, etc record, the record is NOT being selected
and thus the form is not opening. Things work fine for the 1st record
since its automatically selected.***

Question: How can move automatically select a record when the mouse
moves over it without clicking on the Record Selector or moving the
focus to a field on the subform.

David H
 
Not sure why you're seeing what you are (although it may be that the
double-click event is running before the form moves to the new record), but
may I suggest that you just put a command button on the subform (in the
Detail section) that will open the form you desire when it's clicked? Much
easier to handle, and no problem such as you're now seeing. And it's more
obvious to the user what he/she needs to do to get the "other" form to open.
 
One solution I have used is to put a TRANSPARENT button (Transparent property =
Yes) on top of the entire detail section and use its events to run my code.

You still need a way for the user's to know they need to double click to open
the record.
 
Back
Top