Selecting rows from Datasheet View

[MatthewGrace]

Within a blank form, I have dropped a subform control which is displaying the contents of the Orders table in Datasheet View.



I'd like the user to select multiple orders (rows) from this Datasheet by clicking a checkbox or something on the left hand side of the subform control. After which, they can press a command button that will execute some code as I please on each of the selected rows... I notice there is no "select row" feature of the Datasheet View, but this seems like it would be a common scenario. I've imagined a solution of creating an unbound checkbox and placing it as the leftmost column, and the user can place a check in the box to "select the row". Then, they can Press the command button which will somehow peruse the contents of each row (via code) in search of a "checkbox.value = true" condition and then take desired action on that row.

I'm posting this because I think I can figure that out but was wondering if there is a practical standard for this kind of action, another way that I'm not aware of. If anyone has any information on programming for selected rows in Datasheet view that runs contrary to how I've described it, please share. Any thoughts appreciated,

Matt

[burrina]

To select the row try this. Run from Main form.

With Me.[NameOfYourSubformControlHere]
.SetFocus
.Form![NameOfSomeControlOnTheSubformHere].SetFocus
RunCommand acCmdSelectRecord
End With