I have a front-end back-end database that works very well, except for one form that takes over a minute to open. The form is bound to a qry that is based on 4 linked tables, although the majority of data (about 90%) comes from only one table.
There are 4 combo's on the form (2 of which are linked to about 150 records each and the other 2 to about 5 records each). There is also about 15 text fields on the form.
Even opening the form in design mode takes over a minute.
I have 4 domain functions on the form, which I deleted, but that didnt improve performance at all. The form does not display any data when first opened, until such time as a selection is made in the first combo box. Changing the recordset type to snapshot (just to test) also makes no difference.
All other forms in the database open relatively quickly - around 1-3 seconds or so.
Any ideas or suggestions much appreciated.
There are 4 combo's on the form (2 of which are linked to about 150 records each and the other 2 to about 5 records each). There is also about 15 text fields on the form.
Even opening the form in design mode takes over a minute.
I have 4 domain functions on the form, which I deleted, but that didnt improve performance at all. The form does not display any data when first opened, until such time as a selection is made in the first combo box. Changing the recordset type to snapshot (just to test) also makes no difference.
All other forms in the database open relatively quickly - around 1-3 seconds or so.
Any ideas or suggestions much appreciated.