Combo box row source in a split database
Posted on 2005-04-15
I have a form that has a combo box which is used to go to specific records. As you type the company name, the combo box contents advances with each letter. When the company is selected, pressing enter will display that company in the form. The form's record source is a query that is created using QueryDef when the user logs in prior to opening the Comapny form. On the comppany form there are several buttons that will change the record source of the form ( All Companies, My Companies, Calls Due). All queries are created at login. Each time a button is clicked to change the record source the underlying query updates to reflect the records in the query. The row source is based on the current record source of the query.
The combo box works perfectly well. The problem is that when I split the database, there is a huge delay as the user types in each letter to the combo box. Then, the impatient users will backspace and compound the problem. I assume that with each letter typed, the row source query is executing on the table that is located on the server. Is there a way to take a snapshot of the query and have it located on the user's local database. In other words, when a button is clicked and the underlying query is executed, can a copy of that query be a table on the user's local database and that table would then be the row source of the combo box?
Also, if there is nothing in the combo box that matches the typed letters and the combo box is empty, a message appears saying that something must be entered. Is there a way around this?