
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.