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
| Private Sub Liste2_DblClick(Cancel As Integer)
Dim IDart As Long
Dim nbr As Long
nbr = Liste2.ListCount - 1
If nbr <= 0 Then
Exit Sub
Else
DoCmd.OpenForm "frm_Patientez"
DoEvents
IDart = Liste2.Column(0)
DoCmd.OpenForm "frm_ModifArticleOuest", acNormal, "", , , acNormal
Forms("frm_ModifArticleOuest").idArticle.Value = IDart
Forms("frm_ModifArticleOuest").NomArticle = DLookup("[Nom_Article]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").idArticle)
Forms("frm_ModifArticleOuest").TypeArticle = DLookup("[Type]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").idArticle)
Forms("frm_ModifArticleOuest").FormatArticle = DLookup("[format]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").idArticle)
Forms("frm_ModifArticleOuest").PromoArticle = DLookup("[promotionnelle]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").Form.idArticle)
Forms("frm_Patientez").Repaint
If Forms("frm_ModifArticleOuest").PromoArticle = True Then
Forms("frm_ModifArticleOuest").Datedébut.Visible = True
Forms("frm_ModifArticleOuest").DateFin.Visible = True
Forms("frm_ModifArticleOuest").Datedébut = DLookup("[date_de_début]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").idArticle)
Forms("frm_ModifArticleOuest").DateFin = DLookup("[date_de_fin]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").idArticle)
Else
Forms("frm_ModifArticleOuest").Datedébut.Visible = False
Forms("frm_ModifArticleOuest").DateFin.Visible = False
Forms("frm_ModifArticleOuest").Datedébut = DLookup("[date_de_début]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").idArticle)
Forms("frm_ModifArticleOuest").DateFin = DLookup("[date_de_fin]", "[tbl_ArticleOuest]", "[ID_Article] = " & Forms("frm_ModifArticleOuest").idArticle)
End If
End If
DoCmd.Close acForm, "frm_Patientez"
End Sub |
Partager