Data Entry Form increaded performance

[Carlee]

Hi there,

I have a form that is used exclusively to entry new tests and readings (test is main form, reading is a subform). It works well when i use a query as the recordset, but i have a problem. My record set has over 40,000 records in it, and it is being served to the form over a network. this slows everything down significantly.

What can i do to make this form faster?

Regards

Carlee

 

[Jonathan Parminter]

-----Original Message-----
Hi there,

I have a form that is used exclusively to entry new tests

and readings (test is main form, reading is a subform).
It works well when i use a query as the recordset, but i
have a problem. My record set has over 40,000 records in
it, and it is being served to the form over a network.
this slows everything down significantly.

What can i do to make this form faster?

Regards

Carlee
.

Hi Carlee, you can retrict the records loaded when the
form starts.

One way is to set the form property DataEntry to Yes.

Another is in the query have the record id with a
criterion of 0. Assuming that this is an Autonumber field.
This will return an empty recordset.

Luck
Jonathan