Richard,
Erik's code is impeccable as usual. But if you want to have the combo boxes show their values when you click on a page you will need to load the combo boxes for that page in the Page Activate method. You can close the table in the Page Deactivate as well.

Don't forget that instead of Erik's

USE Mysource IN 0
THIS.RowSourceType = 2 && Alias
THIS.RowSource = "MySource"

You will need to use

USE Mysource IN 0
THIS.cboLookup1.RowSourceType = 2 && Alias
THIS.cboLookup1.RowSource = "MySource"

since your code will be in the parent of each combo.

Then in the Deactivate method, put
USE in MySource
USE in SecondSource
...

HTH
Barbara


>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.