Drop down list box

[Earl]

I have a number of responses to a survey question and
have been stumped on how to create a drop down list to
enter the data.The question is How long have you lived at
X?

Less than 3 months
3 months to 11 months
1-2 years
3-5 years
6 years or longer
Don't Know
Don't live here

Little help please?

 

[tina]

first of all, you don't do it in a table. don't use the LookUp Wizard. for
reasons why not, see the following link:

http://www.mvps.org/access/lookupfields.htm

instead, suggest you list the ranges in a little table of their own, as

tblRanges
RangeID (primary key)
RangeName

i'll call your data table "tblAnswers". in tblAnswers, make sure the field
that holds the answer to "How long have you lived at X?", is the same data
type and length as the RangeID field in tblRanges.

create a form to enter the survey answers (if you haven't already). *in the
form*, use the Controls Wizard to create a combo box bound to the "How
long?" field, selecting the option "I want the combo box to lookup the
values in a table or query." and clicking Next. then select tblRanges from
the table list and click Next. continue following the dialog box prompts to
finish the task.

hth