Now that all my client's data is on a SQL server (and my Access 2000
front-end applications were relinked to the SQL tables), one of the forms
starts displaying records out of order after working with it for a while.
The front-end form is a simple credit card reconciliation form (it is a
continuous form). The form displays all credit card charges submitted via
the employees' expense accounts with the employees' names, the date of the
charge, a description of the charge, the amount and a checkbox to clear the
charges when they are billed from the credit card company. When the user
first opens the form, the records are displayed properly (i.e. sorted by
employee's last name, first name and then date). As the user works through
the billing from the credit card company and checks the reconciled checkbox,
she suddenly sees records for employees who should have appeared on earlier
pages on the page she is working on. For eaxample, she may have worked
through the H's and is now working on the I's when she will see charges for
an employee with a last name that begins with B further down the page. If
she closes the form and then reopens it, all records are again in proper
order. But, again, after she works with the data for a while, records start
appearing out of order. The form may display up to 500 - 600 records at a
This weird behavior only began after the data was moved from Access 2000 to
SQL server 2000, so it must be some SQL issue.
Does anyone have any idea what's going on here and how to fix it?
Thanks in advance for any help!