"Mark A. Sam" wrote in message
...
Orna,
I may be misreading what you are attempting to do, but it seems like you
are trying to set the Roecordsource property of the form
[Form_frmDoobloFileDetails] from a recordset variable:
Set Form_frmDoobloFileDetails.Recordset = rsNew
I believe this is wrong, however I may be misunderstanding or not familiar
with your method.
Mark, one can set the Recordset property of a form to a recordset object.
What the poster is trying to do is a legitimate action in ACCESS.
--
Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/