My Forms opens in 2 different sort order erratically

  • Thread starter Thread starter Bruno
  • Start date Start date
B

Bruno

I Hide the Header Form and open the Detail Form bound to a temporary
table which I previously prepared with the 24 records of the 24
accounts for that day.

The first time you go into the Detail form is sorted in the correct
order. But if I go back to the Header Form and Back again to the Detail
Form for that day or any other day I select, the order now changes. In
the table the order is correct.

When this happens, I've noticed that not all the fields display until
the form is refreshed (60 seconds default)

Other than displaying a field with the sequence I need and clicking at
the "Sort icon" I'm going crazy trying to solve this one.

Thanks,
 
Bruno said:
I Hide the Header Form and open the Detail Form bound to a temporary
table which I previously prepared with the 24 records of the 24
accounts for that day.

The first time you go into the Detail form is sorted in the correct
order. But if I go back to the Header Form and Back again to the
Detail Form for that day or any other day I select, the order now
changes. In the table the order is correct.

When this happens, I've noticed that not all the fields display until
the form is refreshed (60 seconds default)

Other than displaying a field with the sequence I need and clicking at
the "Sort icon" I'm going crazy trying to solve this one.

Thanks,
Click to expand...

I'm not sure exactly what's going on, but unless you base your form on a
query that explicitly sorts the records, the sequence in which the
records are presented on the form is arbitrary -- some might even say
"whimsical". <g>
 
Back
Top