Form ingnores sorting. Pulldown list ignores it too. What could be the culprit?

A

apolinaras

I have Access97 front end with MySQL providing data via MyODBC.

On all the systems that have WinME the form in question pulls up
everything just fine, 2 systems that have WinXP ignore the sorting.

Form is pulls data from one table.
Any ideas what could it be. Setup and access file is identical on all
machines.
 
J

John Vinson

Form is pulls data from one table.
Any ideas what could it be. Setup and access file is identical on all
machines.
Click to expand...

Base the Form on a Query sorting the data as you wish.

MySQL (like other relational databases) does not specify an order of
data in tables; they're unordered "bags" of data.
 
Top