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
| Function ObtenirValeurChamp(ByVal QuelChamp As String, ByVal QuelleTable _
As String, ByVal ChampCritere As String, ByVal Valeur As String) As String
Dim oRS As DAO.Recordset
Dim SQL As String
Dim strFindFirst As String
  SQL = "SELECT * FROM " & QuelleTable & ";"
  strFindFirst = "[" & ChampCritere & "] = " & Chr(34) & Valeur & Chr(34)
  Set oRS = CurrentDb.OpenRecordset(SQL, dbOpenDynaset)
  With oRS
    .FindFirst strFindFirst
    If .NoMatch Then
      ObtenirValeurChamp = "Aucune occurence trouvée"
    Else
      ObtenirValeurChamp = .Fields(QuelChamp).Value
    End If
    .Close
  End With
  Set oRS = Nothing
End Function
Private Sub txtTrouver_LostFocus()
  MsgBox "Valeur trouvée :" & ObtenirValeurChamp("Age", "datAuthors", _
  "Nom", Trim(Me!txtTrouver))
End Sub |