language to sort by a column in a subform

[bbatson]

Suppose I have a form named Form1. On Form1 there is a subform named Subform1. Subform1 shows all transactions (and the date of the transactions) for the customer selected on Form1. I am trying to sort by the date of the transaction on Subform1. I have set the "order by" field to sort descending by date but it's acting funky (sometimes it is sorted correctly, sometimes opposite, sometimes mixed). I cannot figure out why this is. So, I figure a possible solution would be to have SQL language sort by the date in the Subform automatically when the form is opened. What would be the appropriate language? Thank you!

[ADezii]

Suppose I have a form named Form1. On Form1 there is a subform named Subform1. Subform1 shows all transactions (and the date of the transactions) for the customer selected on Form1. I am trying to sort by the date of the transaction on Subform1. I have set the "order by" field to sort descending by date but it's acting funky (sometimes it is sorted correctly, sometimes opposite, sometimes mixed). I cannot figure out why this is. So, I figure a possible solution would be to have SQL language sort by the date in the Subform automatically when the form is opened. What would be the appropriate language? Thank you!

Before you do anything else, is the Transaction Date Field in the Sub-Form bound to a Field that is of the Date/Time type?

[bbatson]

It is not bound to anything. In this hypothetical, the form and subform would be linked by a customer ID.

[ADezii]

It is not bound to anything. In this hypothetical, the form and subform would be linked by a customer ID.

Set the RecordSource of the Sub-Form to a Query or a SQL Statement with an ORDER BY [Transaction Date] Clause.