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 1
CipherISAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
CipherISConnect With a Mentor Author 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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.