I'm having loading speed problems with form that I've created, containing a subform linked to a stored query. The form is called by another form, and both are using the same recordset/query.
The first form allows the user to search through the table and will return a recordset based on the search criteria. Once the user has found the required record, they will open the second form (which takes the record's primary key as an OpenArg), and will perform a Findfast (using the OpenArg) to get to the required record. The recordset from the first form is cloned for use in the second.
The recordset used contains about 70 fields and the table that it references contains upwards of 40000 records (increasing by ~400 per day).
I have a feeling that if I pass the recordset calculated by on loading the first form to the second form will help with the speed of loading the second form, but have no idea how to pass recordsets between forms.
I've tried indexing the used fields and compacting the backend, but this seems to make very little difference to the load-times of the forms.
Can anyone please help?