Combo Box Error

[Kathy]

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.

 

[Larry Daugherty]

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

HTH

 

[John W. Vinson]

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?