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

Access sorting fields in sub and sub-subforms.

P: 1
My database has a main form with a subform with several sub-subforms. When I sort data in my sub-subforms, the sort will save while viewing only the subform and sub subform but not when linked to the main form. Does anyone know how to fix this?
May 22 '07 #1
Share this Question
Share on Google+
1 Reply

puppydogbuddy
Expert 100+
P: 1,923
My database has a main form with a subform with several sub-subforms. When I sort data in my sub-subforms, the sort will save while viewing only the subform and sub subform but not when linked to the main form. Does anyone know how to fix this?
You did not provide much to go on, but try the following:
If the Order By property is being set within your subfoms, it probably should not be set in the main form....so place your main form in design view, and blank out its Order By property if one is set. If you are setting this property via code, review the code behind the main form and correct as applicable.
May 22 '07 #2

Post your reply

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