Combo Box Too Slow

[Jody]

I currently have a form where the user needs to select a
part number from a combo box. The combo box is using a
table extract from our order entry system and currently
has over 274,000 records. The problem is that when I use
a query it takes 50 seconds for the combo box list to show
up versus 20 seconds if I use the raw data table (even 20
seconds is still too slow). Also, when using the query to
generate the listing, the user can type in the part number
to quickly go to the record on the list. In the raw data
table, the user must use the navigation bar to find the
record.

Any suggestions on how to make this more user friendly and
faster?

Would appreciate any help you can offer.

 

[Pavel Romashkin]

This seems awfully slow for a simple SELECT query. Is the criteria field
properly indexed?
If your combo box is using a calculated expression, you may want to
limit the search domain first (for example, using an unbound "Filter"
text box), then calculate the contents of the combo box.

Pavel

 

[Jody]

The table is an extract from our order entry system that
runs each night and is stored on our network for others to
use. There is no indexing on this table and I'm not
permitted to make any changes. Is there a way of
incorporating some sort of indexing in a select
statement? I'm not using any calculated expression --
just a simple part/description lookup.

I'm very new to VB so I'm not sure what's possible at this
point.

Thanks!

 

[Pavel Romashkin]

I think you could create a new temporary table with indexed fields. This
should increase the query speed dramatically.
Just use standard make table query to create the table by selecting the
relevant fields from your order entry system, change fields to Indexed
and go from there.

Cheers,
Pavel