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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

REUSE OF DATACOMBO SLOWS DOWN APP PERFORMANCE

Status
Not open for further replies.

Judai

Programmer
Oct 23, 2002
42
0
0
IL
Hello,

I have a DataCombo that displays products names.
Such as follows:
Code:
With cmbProduct
    'Set .DataSource = Adodc5
    .DataField = "ProductID"
    .BoundColumn = "ProductID"
    Set .RowSource = Adodc4
    .ListField = "ProductName"DataCombo.
End With

After inserting a whole receipt into the database using this
combo to select the products, the form reloads (I am calling Form_Load subroutine).

After a few cycles like this one, the datacombo and the whole application starts to function very slowly.

I am setting the recordsets to Nothing.

Does anyone know what to do?

How to flush all the memory that is consumed by the application?

I am using ADODC's on that particular form.

HELP.

Thanks.
J.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top