I have a small problem - my programmer is in Europe right now, and I need to add some basic functionality to a form. I want users to be able to 'Select all of the rows' (which would mean checking all the boxes - via a checkbox within the grid. Similar to a hotmail/yahoo mail delete all, only I don't want to delete these rows. I have other updates that will be done, I simply need to know how to check all of the boxes returned by the grid. I thought it would be as simple as setting up an on click event for the button on the form to make the checkbox true - this is clearly either not the case, or I cannot figure out hot to call the object in order to update it within the grid.
The Grid is a subform named: subfrmEditBelforGlobalGrid
The check box is name Selected
The command button objec to click on is named btnSelectAll
Here is the code I currently have for btnSelectAll:
Code:
Private Sub btnSelectAll_Click()
'Created by WCH on 8.8.06
'This may not work at all
On Error GoTo Err_btnSelectAll_Click
Run Select_All
Exit_btnSelectAll_Click:
Exit Sub
Err_btnSelectAll_Click:
MsgBox Err.Description
Resume Exit_btnSelectAll_Click
End Sub
What code do I need to be called when I run Select_All in order to populate all rows in the grid with a checked box?
I have posted some screen shots to help in the explanation, which I assume is lacking.
http://willhullinger.blogspot.com/
Thanks for any help
W
Datagrid
