Sorting records after new entry

[eussias]

I have a VBA application consisting of 8 forms... what I'm hoping to achieve is, after a new record has been added, I want the records to then be sorted on the primary key... doesn't seem to be working for me at the moment... any ideas??

 

[neilkonitzer]

Can you be more specific? It's hard to give a solution to the problem with a limited amount of information. Neil Konitzer, President
Freisoft

http://www.freisoft.com

 

[JoaoTL]

Hi, assuming that you have all 8 Forms open at same Time, try to do this for Each Form after append some new Data

1 - For the Main Form

Me.Refresh

2 - For the other Forms dont use refresh because is not aloud, use Requery like this.

[Forms]![Form1].Requery
[Forms]![Form2].Requery
[Forms]![Form3].Requery
[Forms]![Form4].Requery
[Forms]![Form5].Requery
[Forms]![Form6].Requery
[Forms]![Form7].Requery

3 - If you have Sub Forms use like this

[Forms]![MAINForm1]![SUBForm].Requery

Hope it helps
Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access