I have an Access 97 form connecting to SQL Server through an odbc connection.
My form is set up that when a user enters an Order Number into a textbox and presses the tab key to move to the Price textbox, the Price
textbox information is retrieved from another table which is done through a myform.requery command.
When I was using Access as my backend, this routine worked quickly, but since I've moved to the odbc connection method, it takes a very long time.
Is there a better way to achieve this?
My form is set up that when a user enters an Order Number into a textbox and presses the tab key to move to the Price textbox, the Price
textbox information is retrieved from another table which is done through a myform.requery command.
When I was using Access as my backend, this routine worked quickly, but since I've moved to the odbc connection method, it takes a very long time.
Is there a better way to achieve this?
