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:Originally posted by danisk
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.
Comment