Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Guatemala City
    Thanked 0 Times in 0 Posts

    Recordset Clone (Win XP Access 2003)

    Could someone explain some concepts to me, please. I am working through some Access Visual Basic code examples, and have a question.

    The example opens a RecordsetClone from a form, uses the FindFirst method to lookup a record, then uses the Bookmark method to move to the record for the underlying form.

    What is the purpose of the Clone? Could you not do this with the table directly?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts

    Re: Recordset Clone (Win XP Access 2003)

    The recordsetClone is another way of looking at the recordset behind a form. This may have been a table, or a query that joined two or more tables. The code you were looking at was designed to find a specific record in the form's recordset and make it the current record on the form.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts