Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
SQL = "SELECT N°MOUVEMENT, NOM, DATE, TYPE_MOUVEMENT, ENTREE, SORTIE, SOLDE, NOM_SOCIETE, N°LETTRE_VOITURE FROM CompteMouvements Where CompteMouvements!N°MOUVEMENT <> 0 "
If Not Me!chkSociété Then
SQL = SQL & "And CompteMouvements!NOM = '" & Me.CmbRechSociété & "' "
End If
If Not Me!ChkTransporteur Then
SQL = SQL & "And CompteMouvements!NOM_SOCIETE = '" & Me.CmbRechTransporteur & "' "
End If
If Not Me!ChkFinPériode Then
SQL = SQL & "And CompteMouvements!DATE <= #" & Format(Me.TxtFinPériode, "mm/dd/yyyy") & "# "
End If
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
CurrentDb.QueryDefs("RequeteTest").SQL = SQL
TxtSoldeTotal = DSum("SOLDE", "CompteMouvements", SQLWhere)
Me.LstResultatRech.RowSource = SQL
Me.LstResultatRech.Requery
Partager