Help with DOUBLE CLICK event on a subform

[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

 

[Ken Snell [MVP]]

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.

 

[John Spencer (MVP)]

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.

 

[David C. Holley]

That would work. As far as communicating it to the users, since I'm the
only user at this point I'm pretty sure that my memo will be read. Aside
from that, the abilty to double click on a subform (or form displaying
continous records) to view the detail is pretty much a standard thing
that I always build in.

David H
COme on baby light my fire: www.spreadFireFox.com