MS Access Value List

I have a value list on a form.  The original values were "In Progress, Waiting, Completed, Deferred".  I changed it to "Open, Closed".  The new values are not displaying in drop down.  The old values are.

How do I get it to display the new values.
ValueList.jpg
LVL 2
CipherISAsked:
Who is Participating?
 
CipherISAuthor Commented:
I figured out the issue.  It was in the table in the lookup tab.
0
 
Rey Obrero (Capricorn1)Commented:
did you save the changes?
try closing the form, then do a compact and repair

test again
0
 
CipherISAuthor Commented:
Tried that - it still shows old values
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Rey Obrero (Capricorn1)Commented:
are you sure you change the value for the correct combo box? form?


upload a copy of the db
0
 
CipherISAuthor Commented:
can't upload db.  Yes - i'm sure its for correct combobox on form.
0
 
Rey Obrero (Capricorn1)Commented:
<can't upload db.>

create a blank db, import the form from your db..

upload the created db.



check if the column count is set to 1
check if the column widths is set to 1
0
 
Rey Obrero (Capricorn1)Commented:
so you did not actually see the

 "In Progress, Waiting, Completed, Deferred"

from the Row source of the combo in the FORM?
0
 
IrogSintaCommented:
Table Lookup fields strikes again. My recommendation would be to not use lookups fields at all. They cause more trouble then they're worth and using them detracts from learning how table relationships work.  Check out this link that shows many of its problems.

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

Ron
0
 
Rey Obrero (Capricorn1)Commented:
@Ron,
Kumusta na?
0
 
IrogSintaCommented:
@Rey,
I've been quite busy with school :-)
0
 
CipherISAuthor Commented:
@IrogSinta

I totally agree.  Unfortunately, I did not create this database but I'm stuck working with it.  I would have created a separate table for the values.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.