G
Guest
On Form- A I have ComboBox-B with RowSource that selectes the records to be
displayed. the records consist of fields showing athletic events, skill
levels and age category for the event: Solo, Advanced, 10-12. This works
fine. when I select a record in ComboBox-B subform-S displays a recordset of
who competed in the Event, Level, and Age Group as selected in ComboBox-B.
the problem is that after the subform is populated the current record
selector in ComboBox-B changes to the selected event, level and youngest age
of that group. Then when I try to resort the records in the subform in a
different order (score, rank, or by name) I get the records with the youngest
age (0-6), not the record set I originally selected.
Why would the current record pointer change? I have looked for a refresh or
a requery in the module but there are none that get executed when the problem
happens. anyway I think a requery or refresh of ComboBox-B would cause the
pointer to reset at the top of the record set, not just move 4 or 5 records.
HELP
Steve S.
displayed. the records consist of fields showing athletic events, skill
levels and age category for the event: Solo, Advanced, 10-12. This works
fine. when I select a record in ComboBox-B subform-S displays a recordset of
who competed in the Event, Level, and Age Group as selected in ComboBox-B.
the problem is that after the subform is populated the current record
selector in ComboBox-B changes to the selected event, level and youngest age
of that group. Then when I try to resort the records in the subform in a
different order (score, rank, or by name) I get the records with the youngest
age (0-6), not the record set I originally selected.
Why would the current record pointer change? I have looked for a refresh or
a requery in the module but there are none that get executed when the problem
happens. anyway I think a requery or refresh of ComboBox-B would cause the
pointer to reset at the top of the record set, not just move 4 or 5 records.
HELP
Steve S.