Can anyone point me in the direction of the following?
I have a Access 200 database with a form, which in turn has a sub form in datasheet format. The main form opens and the data is displayed but I want it to be sorted. The subform is using data from a table as it needs to be able to be edited.
Any ideas how this can be done? I have tred the sorting and grouping button, which works for the subform itself, just wont work when the main form opens the subfrom within itself... (if that makes sense )