Recordset, changed at runtime, only shows 1 record 
Author Message
 Recordset, changed at runtime, only shows 1 record

Need help on a recordset, changed at runtime, only shows 1 record.

Scenario:

A person has an address and belongs to a group.

Objects: datPerson, txtAddress, cboGroup

datPerson is bound to Access 97 db (I have DAO 3.51 referred to and
not DAO 3.6)

txtAddress is bound to datPerson and 'Address' field in 'People' table
of db.

cboGroup is bound to datPerson and 'GroupType' field in 'People' table
of db.

In Form_Activate datPerson populates cboGroup via SQL query.

In cboGroup_Click I want the selected value to run a different SQL
query to filter the recordset of datPerson to only show the records
that contain that particular selected value.

I was able to accomplish this but it only shows the first of many
records that contain that particular selected value.

It is not any sort of display error since I tested to find that the
recordcount = 1 when it should = 3.



Tue, 04 Nov 2003 12:54:56 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Changed at run-time recordset only shows 1 record rather than many

2. recordset record position change upon the Datacombo change...

3. recordset record position change upon the Datacombo change...

4. recordset record position change upon the Datacombo change...

5. newbie - not all records show in recordset

6. Recordset's showing changes

7. Runtime error when reading next record in recordset

8. Runtime error when reading next record in recordset

9. Module-level multiple-record recordset vs temp single-record recordset

10. Module-level multiple-record recordset vs temp single-record recordset

11. Changing Current Record of Related RecordSet

12. Hyperlink color changes if I click on one record of a recordset

 

 
Powered by phpBB® Forum Software