WINDOWS version: 7 Pro 64bit
ACCESS version: 365 (I didn't see this as an option when picking the Access version)
The "frontend database" (interface) is stored in a folder on the C: drive. The linked "backend database" (data) is in a folder on a server. All functions are on one table in the backend. No relationships.
In the frontend there's a form with 3 fields for search criteria with a "SEARCH" button that triggers an Requery in the form's source query. There are also 3 buttons that sort the data and search results by 3 different fields using OrderBy. All buttons have a Beep command that occurs after results are complete.
Everything was working in Access 97. After converting the both the frontend and backend MDBs to ACCDBs, the issue started. (97 to 2003 to 2013)
If I type in the search criteria field(s) and click the SEARCH button, nothing happens except the Beep. But if I click any of the 3 sorting buttons first, I can then click the Search button and it works. Closing and opening the search form doesn't make any difference.
Any ideas will be greatly appreciated.