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.
Best Regards,
Lee Roy J. Pitre, Jr, AAS, BA, MS
Pitre Computer Consultant & Associates
http://pitres.us