Combo Boxes - Filter by Partial Entries?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have a combo box that will select the nearest field based
only on a partial text string that's not necessarily at the start of a string
contained in the list.

For example, say you have a combo box that lists companies and one of those
is Microsoft.

Can you set a combo box so that if someone typed 'crosof' the correct field
would be selected?
 
Doubt it. What you may have to do is have a separate box in which the user
could type partial text, then have the combo box row source be something like:

"SELECT [companyName] FROM [tblCompanies] WHERE [companyName] LIKE *" &
Forms![theForm].[otherTextBox] & "*;"

Which would cause 'Microsoft' to turn up in the combo box because it would
search for names "LIKE *crosof*"

Hope that helps. Good luck.

-ndalton
 
Back
Top