Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Quincy, Illinois
    Thanked 0 Times in 0 Posts

    Changing Recordset Information on each loop (Access 2003)

    This post may belong in the VB forum???.

    I'm working on setting up an output table that will be used for a Bill-of-Material report, to which I will be using visual basic to build this table. My question is, is their a way to change a recordset on each loop of a Do while statement? For instance, I may have a recordset that has 1000 records, but I'm only interested in 15 of those on a specific loop (next loop may be something completely different). I could loop through the entire recordset, but something is telling me that this isn't the most efficient way. What is the most efficient way to handle this?

    Any help is greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Changing Recordset Information on each loop (Access 2003)

    Of course you can open and close a recordset within a loop. You haven't provided enough information to give more specific advice.

Posting Permissions

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