dlookup vs. multiple column combobox

[Joe Williams]

I have a combo box that looks up a part number. The combo box has several
columns of additional data about that part number along with a join to
another table to get some further imnformation. All of this info is then
displayed in text boxes that reference the .column property of the combo
box.

My problem is that there are quite a few records in the part number table,
and when you drop down the combo box it takes almost 20 seconds for teh data
to be displayed in order to select a record.

My question is twofold: 1) Is there anyway to speed up the combo box and 2)
Would just listing the part number in the combo box and doing dlookups in
the text fields be faster?

Thanks

joe

 

[Rick Brandt]

I have a combo box that looks up a part number. The combo box has
several columns of additional data about that part number along with
a join to another table to get some further imnformation. All of this
info is then displayed in text boxes that reference the .column
property of the combo box.

My problem is that there are quite a few records in the part number
table, and when you drop down the combo box it takes almost 20
seconds for teh data to be displayed in order to select a record.

My question is twofold: 1) Is there anyway to speed up the combo box
and 2) Would just listing the part number in the combo box and doing
dlookups in the text fields be faster?

Thanks

joe

You could have the RowSource for the ComboBox only retrieve the row for the
current entry in the Form's current event. For changing the entry use the
GotFocus event to prompt the user for the first few characters of the part
number and then set the RowSource to only retrieve records that match what they
enter. That should significantly reduce the rows returned.