Combo Box Error

I have created a form using the form wizzard, which added all of the data I
needed to my form. However, one of the items on my form is Employee Last
Name. I want to add a drop down box, so that only the names listed are
available for use in the form. However, when I create the combo box it
appears fine in design view, but when I switch to form view and try to
navigate by going to the next record, I receive an error message "the value
you entered isn't valid for this field". This only occurs when I deisgn the
combo box by selecting the option "I want the combo box to look up the values
in a table or query" in the combo box design wizard. The error does not
appear when I select "I will type in the values that I want" in the combo box
design wizard. There are too many names to manually type them all.

Any help would be appreciated.

Try the "go to a record ... " option.

HTH
--
-Larry-
--

"Kathy" wrote in message
...
I have created a form using the form wizzard, which added all of the
data I
needed to my form. However, one of the items on my form is Employee
Last
Name. I want to add a drop down box, so that only the names listed
are
available for use in the form. However, when I create the combo box
it
appears fine in design view, but when I switch to form view and try
to
navigate by going to the next record, I receive an error message
"the value
you entered isn't valid for this field". This only occurs when I
deisgn the
combo box by selecting the option "I want the combo box to look up
the values
in a table or query" in the combo box design wizard. The error does
not
appear when I select "I will type in the values that I want" in the
combo box
design wizard. There are too many names to manually type them all.

Any help would be appreciated.

On Mon, 24 Aug 2009 18:39:01 -0700, Kathy
wrote:

I have created a form using the form wizzard, which added all of the data I
needed to my form. However, one of the items on my form is Employee Last
Name. I want to add a drop down box, so that only the names listed are
available for use in the form. However, when I create the combo box it
appears fine in design view, but when I switch to form view and try to
navigate by going to the next record, I receive an error message "the value
you entered isn't valid for this field". This only occurs when I deisgn the
combo box by selecting the option "I want the combo box to look up the values
in a table or query" in the combo box design wizard. The error does not
appear when I select "I will type in the values that I want" in the combo box
design wizard. There are too many names to manually type them all.

Any help would be appreciated.

Do you have a yuck! Lookup Field in the table? My guess is that the bound
column of the combo is (or should be) a numeric employee ID.

Names - particularly last names - are NOT unique. What will you do with Dave
Jones, his son Dave Jones Jr., and the unrelated Janet Jones?

--

John W. Vinson [MVP]