از این کد استفاده کنید و قسمت های دلخواه رو خودتون عوض کنید
On Error Resume Next
If Adodc1.Recordset.RecordCount > 0 Then
Set Cnn = New ADODB.Connection
Cnn.CursorLocation = adUseClient
Cnn.ConnectionString = Adodc1.ConnectionString
Cnn.Open
'Adoview.Close
sqltxt = "SELECT * From Morakhasi WHERE persenel_id=" & Persenel_id
Set Adoview = New ADODB.Recordset
Adoview.Open sqltxt, Cnn, adOpenStatic, adLockPessimistic
Set Report1.DataSource = Adoview
Report1.Show 1
Else
MsgBox "ÇØáÇÚÇÊí íÇÝÊ äÔÏ", vbExclamation, ""
End If