selecting record in subform

[gazza110]

I have a subform that has a datasheet view. I want to be able to select the record upon the mouse being over this record.


CODE
docmd.RunCommand acCmdSelectRecord

only selects the first record as this is where the record selector is. I want to move focus to which ever record the mouse is over (then once clicked it opens a new form). I have tried goto record without success and tried


CODE
me.setfocus

again to no success. Any ideas anyone ???

Thanks,
Gary.

 

[Remou]

Is the mouse over bit essential? Is it that you wish to open a form and go to the record selected? If so, you can just use the click or double-click event (double click is usually best). For example:

Private Sub CustomerID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmForm", acNormal, , "CustomerID=" & Me.CustomerID
End Sub

Apologies if I have missed your point.

 

[gazza110]

Thanks for this Remou however this is not really what I'm looking for.

I am able to open the form using a click event. The subform is in datasheet format. I the row to turn black (select the record) when the mouse is over it (so the user can tell which record it is they are selecting).

The command: docmd.RunCommand acCmdSelectRecord

only selects the first record (row) on the subform/datasheet. I need to move the focus to where the mouse is (which record it is over).

Any ideas?

Thanks,
Gary.

 

[Remou]

I do not think you can do this. All I can suggest is that you use the click event to highlight the record (DoCmd.RunCommand acCmdSelectRecord) and a double-click to open the form. :-(