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?
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
All Courses

From novice to tech pro — start learning today.