I have a form with which uses a large number of drop down combo-lists for data selection/validation. The form is a multi-page frame form and my preference would be to only load the look-up tables when a particular page is selected. I am maintining data compatibility with a DOS FoxPro application - so need to use free tables and the number of file handles becomes an issue in that it limits the number of concurrent users logged onto the system at any one time. I will need to remove the look-up tables from the data environment - when and where should I open these tables? - if I do not load the table until the control is active - the control appears blank until selected.

Thanks in advance for any advice.