Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform performance degradation

Status
Not open for further replies.

tmorita

Technical User
Jul 31, 2001
18
US
This is a strange one. I have a subform that has a performance degradation problem. When I first open my parent form, the data entry in my subform is extremely fast.(This is only when the subform contains no data) As I add more data to my subform the performance decreases. If I add a new record and clear the subform, the performance is still slow. When I add a record, close the parent form, reopen the form, come back to the same record, performance is good again. I have already looked for objects that were not destroyed in my code. The problem seems arises when I navigate to a record with any data in the subform. As soon as I get to that record, the performance drops.

Any advice would be appreciated,

Tim
 
Check that the 'name autocorrect' options are NOT ticked in the Tools,Options,General tab.

(as per thread702-206410)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top