Searching a Recordset

Results 1 to 2 of 2

Thread: Searching a Recordset

  1. #1
    Join Date
    Dec 1969

    Default Searching a Recordset

    I need to search my database, return the results in a recordset, and then allow the user to search the recordset again to create a subquery. Just wondering if anyone can share an article or set of code that demonstrates how to do this? Thanks.

  2. #2
    Join Date
    Dec 1969

    Default use movefirst to return to the beginning of your r

    &#039;open your recordset code here<BR>&#039;check to see there are records to search<BR>if not rs.EOF then<BR>&#039;1st time you search the recordset and create your subquery<BR>do while not rs.EOF<BR>&#039;create your subquery here<BR>rs.movenext<BR>Loop<BR><BR>&#039;do what you need with the subquery<BR>&#039;second time to search your subquery<BR><BR>rs.movefirst<BR><BR>do while not rs.EOF<BR>.........<BR>rs.movenext<BR>Loop<BR><BR> end if

Posting Permissions

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