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