Search Combo Box (1 Viewer)

[MelissaMuz]

Hello, I was wondering if there is a way to start typing the part name (on the right of the combo box), rather than the part code and have the database find the part I am looking for. I would like it to be stored as the code but searching for the part by name is sometimes much easier.

 

[CJ_London]

google 'access vba FAYT' (Find As You Type), plenty of examples out there

 

[MelissaMuz]

google 'access vba FAYT' (Find As You Type), plenty of examples out there

will look at this, thanks a lot!

 

[arnelgp]

here is also a demo.
open OrderForm and on "Part Code" field, start typing the Part Code or Part Name
you need to search.

view the code of the form (Load event) how to setup the Part Code combobox.

 

[Gasman]

@MajP here has a FAYT set of classes, so search here as well.

 

[MajP]

Solved - FAYT for Multi Column combo code from MajP question

I have used the great code from MajP FAYT on a few forms and some work perfectly and a few have an issue. I read the post Populating Combobox with a lot of data and the link in there. The issues I am experiencing are When I refresh the underlying table (I click a button on my form and it...

www.access-programmers.co.uk

 

[Pat Hartman]

If you don't need to see the number, you can hide the column, OR you can swap the order of the columns in the RowSource so the number is second. In either case add a sort ascending for the text field. If you don't sort the text field, the type ahead will NOT work correctly

If you swap the columns, you also need to change the number of the bound column from 1 to 2..