Combo Boxes and Dynamic lookups (NOT Cascading) (1 Viewer)

[lbenjaminl]

I have long lists in my combo boxes. I have already catorized the data as much as possible. I am looking for a solution that will use a dynamic LIKE clause as the user types and requery or filter the combo box. I have tried a couple of different things, but with no success. Help.

 

[arnelgp]

what have you "tried" that did not succeed?

 

[XPS35]

I think the principle remains the same. Instead of a first combo box, you use a text field. If a value is entered there, you adjust the rowsource of the combobox based on that value. As mentioned, it is difficult to offer help without more information. An example database would also help.

 

[Gasman]

Search FAYT here with @MajP as the poster. He has classes that you just copy in and enter one line normally to use it.

 

[MajP]

Find as we typed

Part of my form is to enter customer's info based on Combo Box. My combo is working if we type the beginning part of the customer name. How can we make it even 3 characters in the middle of the name, can auto find the closest names?. If any sample of database, could you uploaded it here please...

www.access-programmers.co.uk