Problem sorting subform

[zebrastripes]

Hi,

I know this is probably a pretty simple question but how can a subform be sorted (I just want it to sort based on one field)? What it says in the Access help doesn't seem to work.

Thanks,
Zebrastripes

 

[copterdan]

Open your sub-form in design view, open the form properties, select the data tab and click the three dots next to the record source. This will either open up the Query builder for the Query or SQL statement. On the sort line of the field you want to sort, select either ascending or descending. When you are done, hit the “x” to close the window. Access will then ask if you want to save the changes made to the Query or SQL statement. Select yes. Your Sub-Form should now correctly sort.