MissionCreep
Programmer
I have a form with unbound text boxes and a search button at the top, and then the rest of the form has bound controls. The problem is that the query (selecting all records) that is the recordsource of the form has gotten big so that the form takes a lot of time to load over a slow network connection and it really serves no purpose because no one is going to scroll through 50,000 records.
How do I load a blank form and then populate it after the user enters search criteria? Do I have to separate the 2 parts of the form into 2 forms or do I bind the controls in code when the search button is clicked or is there some other way?
How do I load a blank form and then populate it after the user enters search criteria? Do I have to separate the 2 parts of the form into 2 forms or do I bind the controls in code when the search button is clicked or is there some other way?