Build Your Skills: Create connection-sensitive combo boxes in Access

(Susan Harkins and Arthur Fuller) You may be a whiz at writing single-user Access database applications, but youll probably find that an application written for use on a local system falls down once you move it to a client/server environment. For example, a simple combo box that displays a reasonably sized list performs well on a local system with one user. Transfer that same application to a network with a hundred or so users, or use the control to start retrieving thousands of rows of data across the network, and the application may grind to a near halt. Thats because the users that access the form force large and repetitive downloads across the network every time they use the control.