VBA for Recordselector.Click (XP)

Topic

New Reply

Hi

I have a datagrid view subform that you can click on to select records. i want the form to automatically select the whole row (as if you clicked on the record selector) whenever a cell is clicked / moved to.
Im sure this should be simple in VBA – can anyone help?

Thanks

Reply | Quote

Replies

Try this:

Private Sub Form_Current()
RunCommand acCmdSelectRecord
End Sub

Reply | Quote

Hi

works…ok-ish.. but not as good as when i click the record selector. The vba command sometimes selects the whole line, but sometimes opens up the cell within the selection . any other ideas?

Reply | Quote

perhaps using a continous form will help – trying now…

Reply | Quote

If you don’t want users to be able to edit anything, a list box might be a better solution than a datasheet form.

Reply | Quote

Hi

yes, was thinking of a list box, but the continous forms with that runcmd is fine.

Reply | Quote