I need some help with this simple database combo box (1 Viewer)

[josetted7]

Hello all,

I am having a problem with my combo box.

I have the company names in my combo box, however, when I input in the first 4 letters of a name, only 1 name comes up even though I have 4 names that start with the same 4 letters. I want to be able to put in the first 4 letters and all the names with these first 4 letters show up. Can anyone help?

I'm pretty much a newbie, thanks in advance for all you help.

 

[Gasman]

That is how comboboxes work, you only get to see one entry, until you click on it?
If you sort your source by name then you will see them all together when the combo drops down.
If you want to see them all at the same time, you could use a textbox for the criteria and a listbox to show the names that match.

 

[arnelgp]

it is not Sorted by Name so add sorting to it.

select ID, CompanyName from your Table Order By CompanyName;

 

[MajP]

you may be interested in a FAYT

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