Inserisco nella Mask il codice Fiscale clicco su cerca e mi carica
i campi con il primo record
Private Sub cmdCerca_Click()
Dim dbConn As New ADODB.Connection
Dim dbRec As New ADODB.Recordset
Dim ICod As String
g_strConnectionString = "maia"
dbConn.ConnectionString = g_strConnectionString
dbConn.Open
dbRec.Open "Pazienti", dbConn, adOpenForwardOnly, adLockOptimistic, -1
ICod = MaskCodice.Text
While dbRec.EOF
Set dbRec = dbConn.Execute("SELECT * FROM Pazienti WHERE CodFiscale = '" & ICod & "'")
dbRec.MoveNext
Wend
txtNome.Text = dbRec!Nome
txtCognome.Text = dbRec!Cognome
DTPicker1.Value = dbRec!Data
End Sub