Query speed (1 Viewer)

[k209310]

Hi

I have a query on queries.

I have a combobox in which the row source is decided by a query that depends upon the result of another combo selection. My problem is that this combo is very slow to populate. Although the tables where the info is being taken from are not that great in size.

Is there a quicker way to populate a combo or improve the speed that it populates. Would populating the code via code called from an event be quicker that using a query in the row source.

Any advidce is happily recieved

Chris

 

[Fizzio]

Are the combos populated by stored querydefs or SQL statements in the rowsource?

 

[k209310]

sql statements in the row source

 

[Fizzio]

Change them to stored queries initially and see how this affects the performance. In the rowsource, open the qbe grid and save the query. use this saved query as the rowsource (it should update automatically)

 

[Rich]

Post the sql statement

 

[k209310]

Thanks Fizzio ill give it a go

heres the SQL

SELECT DISTINCT [tblEndUserDetails (Original)].[Country] FROM tblEtheylene, [tblEndUserDetails (Original)] WHERE ((([tblEndUserDetails (Original)].[MarketType])=[forms]![frmaddEnquiry]![cmbMarket]));

Chris

 

[Rich]

Do you Requery the second combo on the AfterUpdate of the first?

 

[k209310]

Yes.

When the form is first loaded both combos are empty. Once a selection is made to teh first the second is populated and repopulated if changed.

 

[jaydwest]

Is the MarketType Field indexed? If not set an index on the field. That will help.