Selecting data by combobox

[techkenny1]

Hi all,

On a form I have a combobox which is set up to find data on the form.
The name of the combobox is 'txtFindAsUTypeValue'
and on the chnage event '=FindAsUTypeChange([Form])'
I found this on a web site for access.
It works ok, so if you type in the first letter say'L' then the whole name will appear beginning with 'L'. Normally this is the first name beginning with 'L'
Is it possible to be able to just type, say 'L' and then when the combobox is opened just the names with 'L' will show, and not the first name beginning with that letter.And then you can type the second letter which will shorten the list of names.
Hope this makes sense.

Many thanks,

kp

 

[MajP]

faq702-6304

 

[chigley3]

Where is the coding for that?

i copied everything there but it comes up with an error

Cheers

 

[HarleyQuinn]

Which error?

Andy
---------------------------------
Can't sleep, clowns will eat me!

http://lessthandot.com

 

[MajP]

Take a look at the FAQ I updated to be more flexible and easier to instantiate. It now requires only one line of code to turn any combo into a FAYT combo:

Public faytProducts As New FindAsYouTypeCombo
Private Sub Form_Load()
faytProducts.InitalizeFilterCombo Me.cmbProducts, ProductName", False
End Sub

Also their is an optional parameter to allow you to search from the beginning of the string or anywhere within the string

Read the instructions it is all there. Here is a demo

http://www.4shared.com/file/168902249/a52cc33e/FAYT_Combo_9Dec.html