vba access - refer to the control that was clicked

[bambo]

I've got a form with 72 text boxes, sorted in a 6*12 matrix. the text box names are Cell_[row number]_[Column number].

I'd like that double clicking all the 72 text boxes will call the same function with the paramaters of the Cell's row number and column number.

for example: the sub for cell_0_1 looks like:

Private Sub Cell_0_1_DblClick(Cancel As Integer)
Call OpenCell (me.cell_0_1)
End Sub

is there a way to work this out without writing 72 ugly sub routines?

[DKenny]

No, there's no way around it. VBA doesn't support control arrays, so yo will need to write a _DblClick event for each one.

[bambo]

What about knowing which text box was click and to use it as the paramater for the function:

Private Sub Cell_X_Y_DblClick(Cancel As Integer)
Call OpenCell (me."the cell that was dblicked" )
End Sub

[DKenny]

If you want the code to execute on a Double Click of any/all the textboxes, then you will have to handle it seperately for each textbox.

[bambo]

Yes I got that, I just don't like the "call opencell (me.cell_X_Y)" part, which means I need to get all those 72 subroutines X's and Y's changed according to the cell that is double clicked.

what I want to know is: how do you know which control was double clicked inside a dblick sub?

[bambo]

anyone?

[nagasrikanth]

as the "_" symbol is there... y can't we try for "INSTR","LEFT/RIGHT/MID" functions ????