Launch procedure for subform item 2

[doctorswamp]

Hi All

Have order form, and order items subform in datasheet view. The latter contains a Supplier field for each item, with a DblClick procedure to open an order form to this Supplier, also using other fields from the same row.

Can this be extended so double clicking anywhere in the row, or at its left end, launches the procedure? Like drilling down in say Sage.

I've tried attaching the procedure to the Details section but nothing appears to happen.

Thanks

 

[belovedcej]

I have not yet found a way to do this with a single procedure.

instead, I create a private procedure in the form module:

Private sub launchEvent()
'do something
End Sub

Then, on each control of the subform, on the double-click event, I put the following:
Call launchEvent

I have not found a way to double-click on the left and have that work, too. But this works.

If anyone knows a more efficient way, I would be thrilled!

 

[TheAceMan1]

How are ya doctorswamp . . .

[blue] . . . contains a Supplier field for each item, with a DblClick procedure to open an order form to this Supplier . . . [purple]can this be extended so double clicking anywhere in the row[/purple] . . .[/blue]

The procedures use seems expressly logical to me so I'd leave it the way it is. What you may want to consider instead is [blue]adding a tool-tip across the record[/blue] so users know this can be done . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .