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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 How to sort an index created in Word 2013 0
Sorting 2
Combo boxex, indexing, updating... 1
Allowing Temporary Sorting 1
The changes you requested to the table werenot successful ........ 1
Prevent Duplicate Form Entries 0
How do I create mutiple orders in a subform linked to Customer ID? 2
Custom Sort Order in a Form 2

Back
Top