A
Anthony Spatuzzi
I have a form/subform. They are linked on the field 'cnum'. The fields in
the table 'Received' which is what the subform is bound to are:
Cnum
Ldate
Lbs
Furniture
Clothes
Council
The 'OrderBy' = received.ldate DESC
and 'OrderByOnLoad' = yes
However, when subform opens the records are sorted in ascending order.
To check this I put the following into the 'Current' event of the form:
Debug.Print Me.OrderBy, Me.OrderByOn, Me.OrderByOnLoad
The results of this are:
ldate DESC False True
ldate DESC False True
ldate DESC False True
ldate DESC False True
In order for it to sort in the descending order, I put the following into
the 'Current' event of the form:
Me.OrderByOn = True
which yields:
ldate DESC False True
ldate DESC True True
ldate DESC True True
ldate DESC True True
ldate DESC True True
One point which may be of importance is that I took this form and most
every object from a corrupted dB using the technique outlined by Allen
Browne. I also was fairly certain that I did not pull the corrupting form
into the new dB.
Thanks
the table 'Received' which is what the subform is bound to are:
Cnum
Ldate
Lbs
Furniture
Clothes
Council
The 'OrderBy' = received.ldate DESC
and 'OrderByOnLoad' = yes
However, when subform opens the records are sorted in ascending order.
To check this I put the following into the 'Current' event of the form:
Debug.Print Me.OrderBy, Me.OrderByOn, Me.OrderByOnLoad
The results of this are:
ldate DESC False True
ldate DESC False True
ldate DESC False True
ldate DESC False True
In order for it to sort in the descending order, I put the following into
the 'Current' event of the form:
Me.OrderByOn = True
which yields:
ldate DESC False True
ldate DESC True True
ldate DESC True True
ldate DESC True True
ldate DESC True True
One point which may be of importance is that I took this form and most
every object from a corrupted dB using the technique outlined by Allen
Browne. I also was fairly certain that I did not pull the corrupting form
into the new dB.
Thanks