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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Opens Blank/Appears as if Filter Applied 4
Front end won't compact. Need help refreshing bloated form. 2
2003 ADP connected to SQL Server 2005 - lost sort order 4
Form and Layout Views invisible - what else to try? 2
Sorting a form based on query gives error 2
Form for entry by others...... 4
One main form to update several tables? 3
1 form, 2 tables 3

Top