how can I link a drop list to a query?

[ovello]

I want to create a drop list, so I can do that:

I select an item from the drop list. I detect the ID of the item and, depending of this ID, I select some records from a table.

Can somebody help me?

 

[jubb]

Start by creating the form based on a query containing all the data you want to display, once you have done this edit the form and place a combo box on the form either use a query for the combo list or enter the values you want listed. Don't forget to set a default value for the combo box for when the form first opens. Then edit the query the form is based on in the critaria area (if you are in design view) enter the name of the combo box you have put on the form "=[Forms]![Formname]![ComboBoxName]". You then set the after update property of the combo box to requery the form.
This should do what you want.

 

[ovello]

Indeed, I want to create a combo box. I have a new problem (the previous one is no solved yet, anything else occured). I need to create a easy to use combo box, so the user can work with it as fast as possible. So, let`s suppose I want to create a combo box which contains the customers of an organisation. As we know, the customers can have different names (and the first letter of their names are also different). So... I want to create such kind of combo box that, when the user type a letter in the combo box, the combo box is populated with all the customers names that begin with that letter so the user is able to choose one of them. For exemple... the user types "o" in combo box. Because the user typed "o" in combo box, the combo box is populated only with the customers that have their names beggining with "o" "oradea", "ovello" and so on.

Thank you in advance!

 

[LandSlip]

Have you tried setting the row/source property of the combo box to Ascending Order? Then all the customer names will be grouped alphabetically. When you type "O" all names begining with "O" will be shown together.