Check Boxes in Listview

[Richard Krupa]

Hi all,

When i put the checkboxes in list views how do i check the status of the
check box (True or False) for each row?

Appreciate the help!

Regards,
Richard

 

[tina]

if you're talking about a form in datasheet view, only one record at a time
is the current record. if you refer to the control name of the checkbox in
VBA, Access will look at the checkbox of the current record.

hth

 

[Richard Krupa]

Hi Tina,

I meant the ListView ActiveX control. You can set it so a check box appears
next to each row that allows you to tick it or not, im wondering how do i
test for that.

Regards,
Richard

 

[tina]

i don't know either, Richard. maybe somebody else will post and we'll both
learn something.
fyi, some busy people don't look at "already answered" posts, so hopefully
my addition to the subject line will catch their eye.

 

[Richard Krupa]

Hi Tina,

I worked it out.

Private Sub Command30_Click()
Dim cnt As Integer
For cnt = 1 To ListView1.ListItems.count
If ListView1.ListItems(cnt).Checked = True Then
MsgBox 1
End If
Next cnt
End Sub

Thanks for the help

 

[tina]

for nothing, you mean? <g>
thanks for sharing your solution.