Appena aperta la form eseguo questa sub
Private Sub ReBuildRS()
Dim Percorso As String
Dim dbs As DAO.Database
Percorso = CurrentDb.Name
Set dbs = OpenDatabase(Percorso, False)
If Not rsA Is Nothing Then rsA.Close: Set rsA = Nothing
Set rsA = dbs.OpenRecordset("SELECT * FROM T_Appuntamenti " & _
"WHERE FIX([DataAppuntamento]) Between " & _
Format(DATADA, "\#yyyy\-mm\-dd\#") & " AND " & Format(DATAAL, "\#yyyy\-mm\-dd\#"))