ComboBox Rowsource on GotFocus blank when open form Access FE SQL BE

[detrie]

Hi All,
I have a series of bound combo boxes on a bound form.
In an effort to load the form quickly, the GotFocus event is set to get ROWSOURCE for that combo box. This part is great.

My issue is when I open the form, because the ROWSOURCE for the combo boxes are not available until they get focus, the combo boxes appear empty. Once the combo box gets focus, the data appears.

9 ComboBoxes.

The front end sits on a Citrix machine BackEnd SQL2005
The time penalty is about 14 seconds when opening and "Next Record"

Any ideas on how I could get around this and still get the form permormance I need?

TIA
Detrie

 

[Guus2005]

You probably use bound forms? You can:
- Check if the query to which your form is bound is simple or complex. Try to simplify it by only retrieving the fields you need.
- check your network speed.
- Use unbound forms and use a recordset to populate your form.

HTH