Hi all.
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?

Thanks.

Dave

Egads, why pass the entire recordset to the second form? Open the second form with only the single record the user needs.

SELECT * FROM tblMyTable WHERE [PKField] = " & Me.PKField

HTH

Also, you may want to limit the recordset to the top 100 records, and then only call additional records as needed.

Also, what is the backend? It should be SQL.

mmcdonal