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 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
|
'Structure de l'appel : Me.lenomducontrol c'est le controle qui récupère la 'donnée sélectionnée
'nomdeformulaire est le formulaire de choix utilisateur
cherche Me.lenomducontrol, "nomdeformulaire"
Public Sub cherche(ctl As control, dekoi As String)
Dim passele As Variant
On Error GoTo CapteErr
passele = ctl
ctl = prendle(passele, dekoi)
Sortie:
Exit Sub
CapteErr:
Select Case err.Number
Case Else
MsgBox "Erreur " & err.Number & ": " & err.Description, vbCritical, "Attention"
End Select
Resume Sortie
End Sub
'----------------------------------------
Public Function prendle(var As Variant, leformu As String) As Variant
Dim varTemp As Variant
On Error GoTo CapteErr
varTemp = IIf(IsMissing(var), "0", var)
DoCmd.OpenForm FormName:=leformu, WindowMode:=acDialog, OpenArgs:=varTemp
If IsLoaded(leformu) Then
prendle = Forms(leformu).laliste
DoCmd.Close acForm, leformu
Else
If Not IsNull(varTemp) Then
prendle = varTemp
Else
prendle = Null
End If
End If
Sortie:
Exit Function
CapteErr:
Select Case err.Number
Case Else
MsgBox "Erreur " & err.Number & ": " & err.Description, vbCritical, "Attention"
End Select
Resume Sortie
End Function |
Partager