Hello,
I have a DataCombo that displays products names.
Such as follows:
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.
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.