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
| 'definit la source de la zldGenre
StrSql10 = "SELECT T_Bouture.IdGenre, T_Genre.Genre, T_Bouture.BoutureRempote " & _
"FROM T_Genre INNER JOIN T_Bouture ON T_Genre.RefGenre = T_Bouture.IdGenre " & _
"GROUP BY T_Bouture.IdGenre, T_Genre.Genre, T_Bouture.BoutureRempote " & _
"HAVING (((T_Bouture.BoutureRempote) = False)) " & _
"ORDER BY T_Genre.Genre;"
Me.zldGenre.RowSource = StrSql10
'definit la source de la zldEspece
StrSql11 = "SELECT T_Bouture.IdEspece, T_Espece.Espece, T_Bouture.BoutureRempote " & _
"FROM T_Espece INNER JOIN T_Bouture ON T_Espece.RefEspece = T_Bouture.IdEspece " & _
"WHERE (((T_Bouture.IdGenre) = [zldGenre])) " & _
"GROUP BY T_Bouture.IdEspece, T_Espece.Espece, T_Bouture.BoutureRempote " & _
"HAVING (((T_Bouture.BoutureRempote) = False)) " & _
"ORDER BY T_Espece.Espece;"
Me.zldEspece.RowSource = StrSql11
'definit la source de la zldCultivar
StrSql12 = "SELECT T_Bouture.IdCultivar, T_Cultivar.Cultivar, T_Bouture.BoutureRempote " & _
"FROM T_Cultivar INNER JOIN T_Bouture ON T_Cultivar.RefCultivar = T_Bouture.IdCultivar " & _
"WHERE (((T_Bouture.IdGenre) = [zldGenre]) And ((T_Bouture.IdEspece) = [zldEspece])) " & _
"GROUP BY T_Bouture.IdCultivar, T_Cultivar.Cultivar, T_Bouture.BoutureRempote " & _
"HAVING (((T_Bouture.BoutureRempote) = False)) " & _
"ORDER BY T_Cultivar.Cultivar;"
Me.zldCultivar.RowSource = StrSql12
'definit la source de la zldRefJeunePlant
StrSql32 = "SELECT T_Bouture.RefBouture, T_Bouture.BoutureRempote " & _
"FROM T_Bouture " & _
"WHERE (((T_Bouture.IdGenre) = [zldGenre]) And ((T_Bouture.IdEspece) = [zldEspece]) And ((T_Bouture.IdCultivar) = [zldCultivar])) " & _
"GROUP BY T_Bouture.RefBouture, T_Bouture.BoutureRempote " & _
"HAVING (((T_Bouture.BoutureRempote)=False));"
Me.zldRefJeunePlant.RowSource = StrSql32 |
Partager