>That is the main thing that is slowing down the loading of this form. A few of the combo-boxes are bound to rather large tables, over 30,000 records. I do not understand why using fields or sql in a combo-box is so slow. In ACCESS it is very fast.
A ComboBox is not the appropriate object for selecting from very large tables. A PickField (like the ones used in the Visual Extend sample application) seems much more appropriate to me. If your framework doesn't have this, you have to program a generic PickField yourself, though.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)