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.
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
again to no success. Any ideas anyone ???
Thanks,
Gary.
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.