Sorting by Data

  • Thread starter Thread starter Matthew DeAngelis
  • Start date Start date
M

Matthew DeAngelis

Hi,

I currently have a Transactions form that outputs, in continuous form
view, all of the transactions for a given contact. I would like to
sort it ascending by date; however, it will not do this automatically.
The subform has the Order By: property set to "Calls.[Transaction
Date]", which is the correct field on the table. When the form is
first opened, the dates are out of order. If I click in one of the
date fields, however, and click Sort Ascending, it sorts it properly
for only that usage. If the form is opened again, it reverts to its
old sorting.

Any ideas?

Thanks,
Matt
 
Try creating a query, and specify the sort order there.
Name the query as the Record Source for the subform.

If that doesn't work for you and you want to use the OrderBy property, you
need to set OrderByOn each time the form is opened:

Private Sub Form_Open(Cancel As Integer)
Me.Order By = "[Transaction Date]"
Me.OrderByOn = True
End If
 
Matthew said:
Allen said:
Try creating a query, and specify the sort order there.
Name the query as the Record Source for the subform.

If that doesn't work for you and you want to use the OrderBy
property, you need to set OrderByOn each time the form is opened:

Private Sub Form_Open(Cancel As Integer)
Me.Order By = "[Transaction Date]"
Me.OrderByOn = True
End If
Click to expand...

Thanks...the code works great! I will also consider creating a query
if more problems like this crop up.

Regards,
Matt
Click to expand...

Allen,

I realized that I wanted my form to sort by time as well, so I created
a query and had it sort on both date and time. However, the sort does
not take into account AM and PM. (8:00PM is coming before 11:00AM) Do
you know how to modify the query so that it will sort correctly?

Thanks,
Matt
 
Allen said:
Try creating a query, and specify the sort order there.
Name the query as the Record Source for the subform.

If that doesn't work for you and you want to use the OrderBy
property, you need to set OrderByOn each time the form is opened:

Private Sub Form_Open(Cancel As Integer)
Me.Order By = "[Transaction Date]"
Me.OrderByOn = True
End If
Click to expand...



Allen,

I realized that I wanted my form to sort by time as well, so I created
a query and had it sort on both date and time. However, the sort does
not take into account AM and PM. (8:00PM is coming before 11:00AM) Do
you know how to modify the query so that it will sort correctly?

Thanks,
Matt
 
Back
Top