DoubleClick row in Sub form to launch new Form

[sesproul]

Hello,



I've got this situation in several places, I have two forms. One displays Product detail frmProduct, with a Subform frmsubParts showing all parts that go into the Product. frmsubPARTS is in datasheet view.

the second Form is a for Parts frmPartdetail, with a sub form showing what products this part is frmsubPartsProd. Again the frmsubPartsProd is in datasheet view.


When I double click a line in either Sub form I want to load the form with the detail. what event do I use (I assume that this event will be in the sub form.)

i.e.
frmProduct:frmsubParts

(dclick frmsubParts item 2--------->) Launch frmPartdetail show item 2


this same behaviour occurs in several other forms.


Thanks


Steve

[pbaldy]

This should help:

BaldyWeb wherecondition

[sesproul]

That's helpful for the code to show the form, but I am after the EVENT when you click on the datagrid line.

Steve

[pbaldy]

The double click event of one or more textboxes.

[sesproul]

i actually did code it into the textboxes, But I was wondering if there was a "Record level" selection.

[pbaldy]

Not that I've found. The double click event of the subform wouldn't fire when you double clicked in textboxes, only in open area or on the record selectors along the left. To me, double clicking in the textboxes is most intuitive for the users.