I have a tabular form which displays annual data in month blocks.
The form has a sort function on it and I can sort on all months Desc.
I'm trying to add a field onto the form that'll number rows from 1.. Please bear in mind that when the recordset is re-sorted the row numbering needs to remain static, running from 1.. to the bottom of the form.
This, on the face of it, would seem like a simple thing to accomplish. I can return a row number from a click event by using Me. CurrentRecord but I can't assign this to my row counter text box at runtime.