Positioning in a recordset via clone

G

Guest

Examples of how to display a particular record in a form always use a cloned
recordset. The desired record is found in the clone, then the form's bookmark
is set equal to the clone's bookmark. Why this indirection? Finding the
desired record directly in Me.Recordset seems to work just fine, and is
surely more efficient. Is this undesirable for any reason?
Thanks
 
R

Rick Brandt

TedMi said:
Examples of how to display a particular record in a form always use a
cloned recordset. The desired record is found in the clone, then the
form's bookmark is set equal to the clone's bookmark. Why this
indirection? Finding the desired record directly in Me.Recordset
seems to work just fine, and is surely more efficient. Is this
undesirable for any reason?
Thanks
Click to expand...

Older versions of Access didn't have a Recordset object available in forms and
reports. Code that uses Recordset clone works in all versions. Also in some
cases you actually do want to avoid using the Recordset directly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset clones without a form? 3
Can't Move Cursor in Recordset After Deleting Record 4
Can I use a hierarchical recordset chapter as a subform recordset? 3
Problem with RecordsetClone when form has filter property set 1
recordset clone recordcount ? 1
Me.Recordset vs a recordset variable. 9
Recordset not working 9
succesful RecordSetClone use evades me! Help! 4

Top