1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Option Compare Database
Option Explicit
Private Sub Form_Load()
lstAffaires.RowSource = "SELECT * FROM TBAffaires ORDER BY Affaire"
lstThemes.RowSource = ""
End Sub
Private Sub lstAffaires_AfterUpdate()
Dim strAffaire As String
Dim strThemeAffaire As String
strAffaire = Me!lstAffaires
strThemeAffaire = DLookup("Affaire", "TBThemes", "[Affaire]='" _
& strAffaire & "'")
If Len(strThemeAffaire) Then
lstThemes.RowSource = "SELECT * FROM TBThemes WHERE [Affaire]='" _
& strAffaire & "'"
Else
lstThemes.RowSource = ""
MsgBox "Aucun thèmes pour l'affaire " & strAffaire & " !", , "Désolé"
End If
End Sub |
Partager