By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,462 Members | 1,126 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,462 IT Pros & Developers. It's quick & easy.

How to stop disarrangement of records in ms access subforms.

P: 46
I have a form with a sub-form in Ms Access 2010
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.
Apr 16 '14 #1

✓ answered by jimatqsi

yashuaking,
Have you supplied sorting criteria in the query that is the subform's record source? Or, alternatively, in the Data properties of the sub-form you could fill in the Order By property.

Are you saying you have done that and it doesn't always work?

Jim

Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,240
yashuaking,
Have you supplied sorting criteria in the query that is the subform's record source? Or, alternatively, in the Data properties of the sub-form you could fill in the Order By property.

Are you saying you have done that and it doesn't always work?

Jim
Apr 16 '14 #2

P: 46
The Sub-Form is not based on query neither did I set the Data property on the sub form by filling in the Order By Property. I would do this to get the Result. Thank you very much. You have saved my day.
Apr 16 '14 #3

Expert 100+
P: 1,240
You're very welcome, glad to help. You'll be surprised how much Access can help you when you observe all the little hints that are presented in the properties dialog.

Jim
Apr 16 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.