You may need to test the Form's Open or Load event procedures to see where you
get the best performance - you might even need to invoke the referenced code
just before the form is actually opened. If you aren't familiar with, or don't
feel comfortable with, VBA code, then you might not want to tackle this method.
If you just need a little handholding to get yourself started, post back and I'm
sure someone will pick up on it and give you a hand.