Refresh Form

[John liem]

On of a fields in my FORM has a control source "=Cbo_Product.Column(0)", how come that this field needs time to show its value?, how can I speed up?
John

 

[Rich]

With or without the quotes?

 

[John liem]

Without the quotes

 

[Mile-O]

Does the combo in question have a great number of records which have to be loaded first before the ControlSOurce's value can be evaluated?

 

[John liem]

Hi Mile,

Yes, the Cbo_products has a great number of records. If the value of the Cbo_Products appears on the form, the =[Cbo_Products].Column(0) takes ca. 20 seconds before it shows on the form.

 

[Mile-O]

Then that's why it's taking so long.

 

[John liem]

Thanks Mile, so I assume that there is nothing I can do about it .....

 

[WayneRyan]

john,

You have a large number of rows and I noticed ".Column(0)"

Make sure that all parts of the Where and Order By clauses
are indexed and/or restrict the number of rows.

That's all you can do.

Wayne

 

[John liem]

Thanks Wayne !