updating sort order if index changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem with my forms. I have a database with familyID as the sort order. If I change the familyID, the data is not re-sorted until I exit the form and re-enter... so the record still appears in the same place as before. Is there a way to get the data to resort after the indexed field is changed? (FYI, this is not a key index, because there are duplicates)
 
Requery the form to force it to reload the records in the correct order
without closing.

Note that this will throw you back to the first record. If you wanted to be
at the same record again after the requery, save the primary key value into
a variable, requery, then FindFirst in the RecordsetClone of the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

KB said:
I am having a problem with my forms. I have a database with familyID as
Click to expand...
the sort order. If I change the familyID, the data is not re-sorted until I
exit the form and re-enter... so the record still appears in the same place
as before. Is there a way to get the data to resort after the indexed field
is changed? (FYI, this is not a key index, because there are duplicates)
 
Back
Top