Private Sub Lst_INTITULE_BeforeUpdate(Cancel As Integer)
RefreshQuery
End Sub
Private Sub RefreshQuery()
Dim SQL As String
Dim SQLWhere As String
'Je cherche à afficher le résultat de ma reque^te dans ma zone de liste suivant
SQL = "SELECT EMPLOYE!ID_EMPLOYE, EMPLOYE!NOM_EMPLOYE FROM EMPLOYE, SAVOIRFAIRE, EMPSF Where INTITULE = '" & Me.Lst_intitule & "' "
SQLWhere = Trim(Right(SQL, Len(SQL) - InStr(SQL, "Where ") - Len("Where ") + 1))
SQL = SQL & ";"
Me.lblStats.Caption = DCount("*", "EMPLOYE", SQLWhere) & " / " & DCount("*", "EMPLOYE")
Me.lstResults.RowSource = SQL
Me.lstResults.Requery
End Sub
Partager