i'm begining to get the picture now. Let me see if i have got it right.
You have (lets say) 12 checkboxes.
The user can click any number of these.
When they have done selecting, then you want to hit a command button (GO) that will start the app building.
Right? If not the following will be a load of useless crap.
When they hit the GO button you you loop thorugh all of the 12 check boxes and check the value. If the box is checked then you call the find cust, then you build yuor app, or whatever.
Code:Private Sub cmdGO_Click() Dim i As Integer For i = 0 To 11 If check(i).value = vbChecked Then If findCust(check(i).tag) = True Then 'build app or whatever Else Msgbox "The Customer was not found!" End If End If Next i End Sub Private Function findCust (iCust as String) As Boolean rs.movefirst Do Until (findCust = True) or (rs.EOF) If iCust = rs.CustomerID Then findCust = True End If rs.MoveNext Loop End Sub




Reply With Quote