Is there a way in Vb to search for a specific number of check boxes which are not checked and kept in a database.
e.g a prompt which uyou type in the number of boxes to search for then vb shows them.
Printable View
Is there a way in Vb to search for a specific number of check boxes which are not checked and kept in a database.
e.g a prompt which uyou type in the number of boxes to search for then vb shows them.
If your checkboxes are in an array, then it should be easy. Here's what I did:
Create a new project with a command button, four checkboxes in an array, and a list box. insert this code.
it checks all the checkboxes to see if it's checked and adds those that aren't to a list.Code:Private Sub Command1_Click()
List1.Clear
For x = 0 To 3
If Check1(x).Value = 0 Then
List1.AddItem (x)
End If
Next x
End Sub
good luck,
bob