Hello Oliv'83 comment vas tu?
une petite suggestion:
1 2 3 4
| text_sql = "SELECT tbl_Caravane.Code_Caravane, tbl_Caravane_Reglement.Date_de_réglement"
text_sql = text_sql & "FROM tbl_Caravane_Reglement INNER JOIN tbl_Caravane ON tbl_Caravane_Reglement.Code_Caravane = tbl_Caravane.Code_Caravane"
text_sql = text_sql & "WHERE tbl_Caravane.Code_Caravane)= " & code_Caravane
text_sql = text_sql & "ORDER BY tbl_Caravane_Reglement.Date_de_réglement DESC;" |
ensuite, après changement de la valeur de Code_Caravane le petit VB
listexxx.controlsource = text_sql
Partager