Solved

MS Access Value List

Posted on 2014-02-16
13
17 Views
Last Modified: 2016-05-17
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
0
Comment
Question by:CipherIS
  • 5
  • 4
  • 2
13 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
did you save the changes?
try closing the form, then do a compact and repair

test again
0
 
LVL 1

Author Comment

by:CipherIS
Comment Utility
Tried that - it still shows old values
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
are you sure you change the value for the correct combo box? form?


upload a copy of the db
0
 
LVL 1

Author Comment

by:CipherIS
Comment Utility
can't upload db.  Yes - i'm sure its for correct combobox on form.
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
<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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 1

Accepted Solution

by:
CipherIS earned 0 total points
Comment Utility
I figured out the issue.  It was in the table in the lookup tab.
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
so you did not actually see the

 "In Progress, Waiting, Completed, Deferred"

from the Row source of the combo in the FORM?
0
 
LVL 29

Expert Comment

by:IrogSinta
Comment Utility
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
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
@Ron,
Kumusta na?
0
 
LVL 29

Expert Comment

by:IrogSinta
Comment Utility
@Rey,
I've been quite busy with school :-)
0
 
LVL 1

Author Comment

by:CipherIS
Comment Utility
@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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now