Calculated controls - sorting (2007)

[Egg 'n' Bacon]

OK, here's the next one :)

I have a form based on a table with a couple of text boxes that are populated with calculations from other fields (i.e. TxtTgtClosure equals [DateRaised]+5).

On request, I have put ASC & DESC sort buttons for each field, but those for the calculated controls do not work.

Here's an example of the code I'm using;

Code: Select all

    Me.OrderByOn = False
    Me.OrderBy = "TxtTgtClose"
    Me.OrderByOn = True

BTW, both calculated controls are based on Date fields

[Egg 'n' Bacon]

Ah, sorted it; I needed to base the form on a query with the calculations in that.

[HansV]

Yep - you can't sort on a calculated control, but you can sort on a calculated field from the record source.