Sorting on subforms

[Carrie]

Hi

I'm having a problem with sorting a field on my subform. Have tried setting the sort on the table, query, and orderby property and am still having no luck. It sorts ok as a form on it's own but when it is part of a subform it sorts on the master/child link field. Is there any VBA or any other ways of trying to solve this problem?

Any help will be appreciated!

 

[Oldsoftboss]

Have you tried the query builder in the form recordsource field in the forms properties?
Open the sub-form in design view and double click the square in the top left hand corner to open the form properties. Then when you click in the record source field a box with 3 dots will appear on the RH end. Click this button and build your record source like you would design a query. Select the field you want to sort by. When you close the builder access will ask if you want to update or save (cant remember which) just press yes and this should work
HTH
Dave

 

[Carrie]

Thanks for your reply.

Unfortunately that's what I tried first off! I've tried again but still to no avail!

I will just have to play some more!

 

[Rich]

Right click on the field in the subform, select the sort you want then Save the form, you may have to do this more than once, but Access will eventually accept it

 

[Carrie]

Thanks

I'll give it a try