Sort data on an Access SubForm

[steve_colman]

Hi All,

I have a form with about 4 subforms in a tab control.

The subform in the first tab control tab does not sort the data by the correct field.

The subform itself and the table the data is from sort the data correctly. When you open the subform or the table the data is displayed in the correct oder - which is by the time the task needs to be run.

When you open the subform within the form it is placed in, the order gets messed up.

Anyone know how to solve this?

Thanks

Steve

 

[steve_colman]

Hey! Good news.

For some strange reason re-ordering the query and chaniging the field to test text has solved the issue.

Thanks for the responce's

 

[steve_colman]

Using the query in this way has solved the issue with sorting the data.


But..........

It now means that the data in the form will not update.

Im using a simple select query!!!

HELP