The sub-form is in tabular view which shows records and their dates on entry including Payment Cycle.
The issue is sometimes when data is entered in the sub-form and the form is closed and opened again or refreshed, the records are disarranged.
So for example if data is entered in this manner
Payment Cycle
Date
1 1/2/2014
2 1/3/2014
3 1/5/2014
4 1/6/2014
When form is closed and open again or refreshed, the Records change and are arranged in this manner
Payment Cycle
Date
4 1/6/2014
1 1/2/2014
3 1/5/2014
2 1/3/2014
Please can some help me solve this issue? It is urgent!
I want the records in the sub-form to follow the sequence of when they were entered.