combo box/list

[Guest]

I cannot figure out how to create a drop box/combo box/list (i dont know what
the correct term is). I went to design view and changed it to a combo box,
but how do i get the options that i want to come down when I click the arrow?

 

[Guest]

You could use two options. First you can use the wizard and repeat the steps
you've done before:

Make sure the 'magic'-stick in the toolset is activated. Now place a
combobox on the form and follow the steps.
When done manually then place the combobox on the form. Now rightclick the
combo and choose properties from the menu.

In the properties choose rowsource; you can add a table or query here where
you define the columns you want to see in the combo. Let's say you want to
add a combo with employeenames

Pick a combo and place it on the form
Now choose as rowsource: table employees
Number of columns: 2 (where the first one is the ID field and the second one
is the name from the employee
Columnwidth: 0;
The last meaning don't show the id number but do show the name (with two
columns you can ommit the second value)
Bound column; 1
Meaning the id value is the value being added to the actual record.

So you need to have a field where to store the id from the combo and this th
the controlsource for your combo

hth