Hi all, I wrote a simple code to prompt or alert name of each selected records, but it's not working :
Can some one tell me what's wrong in the code??
Code:
Dim rst As Recordset
Set rst = Me.Child96.Form.RecordsetClone
rst.MoveFirst
With rst
Do Until .EOF
If .Fields("chk") = True Then
zz = .Fields("t_name")
MsgBox zz
End If
.MoveNext
Loop
End With
Set rst = Nothing
Can some one tell me what's wrong in the code??