Data Entry Form increaded performance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
-----Original Message-----
Hi there,

I have a form that is used exclusively to entry new tests
Click to expand...
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
.
Click to expand...
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
 
Back
Top