I am trying to create basic drop down lists in access and am having the
hardest time. I am working with Access 2002 and did not install it myself on
the computer (and don't have the disc). Is it possible that I am missing
necessary addins/wizards and can't do it. The help items that I have read
all seem to talk about a use of a wizard.
Thanks.
It's not necessary to use the wizard. If the wizards aren't working for you
and you don't have the install disk you'll need to do it "by hand".
Use the Toolbox on the form design window. Select the Combo Box tool and place
the combo where you want it on the form. You'll need to set several
properties:
Row Source - the name of a table or query containing the data you want in the
dropdown; it can also be a SQL string such as
SELECT EmployeeID, LastName, FirstName, Department FROM Employees ORDER BY
LastName, FirstName;
Bound Column - a number indicating which field in the RowSource you want to
store
Control Source - the name of the field into which you wish to store that value
Column Count - the number of columns you want to display when the combo is
dropped down
ColumnWidth - a series of ColumnCount numbers separated by semicolons,
indicating the width in inches (or centimeters depending on your settings) of
each column. A zero width conceals the column from view. In the example above
you might have ColumnCount = 4, bound column = 1, ColumnWidths
0";0.5";0.5";1.0". The first nonzero width column will be what's displayed
when the combo is not selected.
John W. Vinson [MVP]
