1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
|
Private Sub chkCode_Click()
Me.cmbRechCode.Visible = Not Me.cmbRechCode.Visible
RefreshQuery
End Sub
Private Sub cmbRechCode_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub Form_Load()
Dim ctl As Control
For Each ctl In Me.Controls
Select Case Left(ctl.Name, 3)
Case "chk"
ctl.Value = -1
Case "cmb"
ctl.Visible = False
End Select
Next ctl
Me.lstResults.RowSource = "SELECT Code, Commune, Etat, Nom, Type FROM Dossiers;"
Me.lstResults.Requery
End Sub
Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT Code, Commune, Etat, Nom, Type FROM Dossiers "
If Not Me.chkCode Then
SQL = SQL & "And Dossiers!Code = '" & Me.cmbRechCode & "' "
End If
SQL = SQL & ";"
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub |
Partager