Calling Two Recordsets Concurrently -- is it possi

Results 1 to 2 of 2

Thread: Calling Two Recordsets Concurrently -- is it possi

  1. #1
    Join Date
    Dec 1969

    Default Calling Two Recordsets Concurrently -- is it possi

    Here is my problem:<BR><BR>Recordset #1 is created from execution of this SQL Statement:<BR>mySQL = "SELECT ID,FunctRec from FunctRec"<BR><BR> 31 records display as checkboxes.<BR><BR>Recordset #2 is a smaller set, created from<BR>mySQL = "SELECT MemberID,FunctRecID from Member_FunctRec WHERE MemberID=" & MemberID<BR><BR>MemberID is a variable passed from a previously executed QuerySt<BR>ring. Recordset #2 yields nine records.<BR><BR>I&#039d like to compare the values from Recordset #2 to the values generated from Recordset #1, so that checkboxes satisfying the condition objRecordset2.Fields("FunctRecID") = objRecordset1.Fields("ID") are CHECKED and displayed on the page.<BR><BR>So rather than having a Cartesian join of 279 records, I&#039d have 31 records, but nine checked thanks to another SQL Query.<BR><BR>I am using Access 97. Can this be done with Access 97?<BR><BR>

  2. #2
    Steve Schofield Guest

    Default RE: Calling Two Recordsets Concurrently -- is it p

    You can use the nextrecordset method of the recordset object. live demo and how to on

Posting Permissions

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