searching in a combo box with the help of *

[benjamin.grimm]

hey guys,

i have a Combo box in a form.

The Combo box gets the data via a querry from a table.

In the table are 6000 customer names.

When i put in now an A, it Shows me all customer starting with an A.

The Problem what i have is that sometimes, the users don´t know the exact Name.

Example

Customer Name in the table Dr. Richard.

So the put in Richard and can´t find the customer in the Combo box.

So my question is, is it possible that the enter *Richard* and the the Dr. Richard Shows up.

Do you know what i mean?

greetz Benjamin

here is mine SQL Code, if you Need that

SELECT [Tabelle_Kunden Stammdaten].DebitorenID, [Tabelle_Kunden Stammdaten].BT_Name, [Tabelle_Kunden Stammdaten].BT_Strasse, [Tabelle_Kunden Stammdaten].BT_PLZ, [Tabelle_Kunden Stammdaten].BT_Ort, [Tabelle_Kunden Stammdaten].BT_email, [Tabelle_Kunden Stammdaten].Telefax, [Tabelle_Kunden Stammdaten].Telefon
FROM [Tabelle_Kunden Stammdaten];

 

[Mr Smin]

In Access 2003 I provided a text box and a button. User puts a few characters of the name in the text box, clicks the button and a list box gets populated with results of their entry with * automatically added. Then they click on the list box item they want.
This is a bit inelegant and later versions of Access may allow something nicer.

 

[benjamin.grimm]

Ok, but i dont know how it works with Access 2010.

There should be something but i don´t know it.

greetz benjamin

 

[spikepl]

Drop combobox. Textbox listbox as Mr Smin says. Sample here: http://www.access-programmers.co.uk/forums/showthread.php?t=188663