Share via

Sort Dates in a Subform

Anonymous
2010-09-16T20:10:29+00:00

I want to sort my forms by the date that is located on a subform. When using the sort feature, it will not sort. Any suggestion? I have a main form called registeration form and the general information is the subform. The field I want to sort is called surgery date. I am working with Access 2007

Thanks

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-09-17T02:15:10+00:00

    well I have a demographics form and the general information is in a separate table . . . .that is why it is in the subform.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-09-16T20:15:40+00:00

    Odd that general information is in the subform instead of main!

    Just add the date field in the main form query for sorting and not show it.

    Build a little, test a little.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-09-16T20:14:53+00:00

    The simpliest way to sort any form, or subform, is to simply specific the sort order directly in the SQL Statement, query,.. used as the form's Record Source.

    If your form is solely based on a table as a record source, then press the ... button that appear on the right-hand side of the Record SOurce property and this will bring up the QBE which will allow you to add your fields and also specify the sort order you require.

    Daniel Pineault

    http://www.cardaconsultants.com

    Free MS Access Tips and Code Samples: http://www.devhut.net

    Was this answer helpful?

    0 comments