Deleting/Changing results in "Value you entered isnt valid for this field"

[thechibicheebs]

Good afternoon, I have a very basic question regarding Microsoft Access 2003.

I currently have a very simple database in Access. It keeps track of
Applications that come in our store. This is its format:

First Name:
Last Name:
Home Phone:
Email:
Store (Combo Box):
Position (Combo Box):
Status (Combo Box):
Active Status (Combo Box):
Not Hired Reasons (Combo Box):
Date Sent to Store:
Date Contacted:
Notes:


Ok, so I decided I wanted to combine "Active Status" and "Not Hired Reasons".
So I deleted "Not Hired Reasons" and entered all the options from that
dropdown into "Active Status". And I changed the name of "Active Status" to
"Status Reasons". I deleted the "Active Status" and "Not Hired Reasons" combo
boxes from the Design View of my Applicants Form. And then recreated a new
Combo Box for "Status Reasons".

Now when I go into the Applicants Form to enter/change Applicants, I get the
"The Value you entered isnt valid for this field" error. It obviously has
something to do with me deleting and recreating in a database that was
already established. I just cant figure out how to fix it. Please feel free
to ask any questions if I was not specific enough.

-Steffane

Note: I backed up the database before I started this mess. So I can pretty
much start from scratch if you have a better way of doing this.

 

[BruceM]

It is not about deleting and re-creating in an established database.

Do you get the error message as soon as you open the Applicants form, or is
it in reponse to a specific user action? Is the Row Source for the new
combo box a query, a field list, or a value list? How did you add the new
values? If it is a query, describe the query. If it is a value list, show
a few examples of items on the list (the full list is not needed).

In what field is the data in the new combo box being stored? Check the
field in table design view to see whether it is text, number, etc. Then
check the combo box bound column to see what you are trying to store. The
bound column will be identified by a number (1, 2, 3, etc.) that shows which
column from the row source query is being stored. You need to be storing a
data type the field will accept. If you are trying to store text in a
number field, it will not work. However, you can store a number in a text
field.