Microsoft Access 2003: Why do drop downs not show all of the information selections that should be available to select from?

A few of the dropdowns in Access database do not show all of the information they need to pick from in the first example.  At the top it says "Type" and has a reference of 174 that nobody knows where that comes from.  It should have "DLR, OEM, HYD" to choose from.  The second one says "Terms" with C.O.D. and the drop down has no more to choose from such as Cash in Advance, Credit Card, Net 30 days, etc.  Please refer to the image in the attachment:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
The properties of the drop downs control how many entries there are (list rows), how many columns (Column Count), which column(s) are shown (Column Widths), and which column is stored in the underlying field (Bound Column).

 Changing anything other than the number of list rows shown can have an impact on other programming that was done.

 Outside of saying that, your question is too general to offer more.   You'd need to dive into the details of what each drop is doing and the code/macros associated with its various events.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
Its clear that you need to check the RowSource of these combo boxes and also check the code behind the form to see if the RowSource is manipulated by some other condition.
Here are the properties you need to look at:
1. Bound column - this will normally be the first column of the RowSource.  It is the field that uniquely defines the items in the list.
2. Column count - this is the count of columns selected by the RowSource.
3. Column width - a string that gives a width to each selected column.  A width of 0, hides the column.  So, typically, the first column width is 0 to hide the numeric value.  Then the text value will be the first visible column.

Make sure that the RowSource query is sorted by the text field that the user sees.  If it isn't, then the type ahead feature will not work correctly.  The second combo also seems to have null entries so since this is pulling actual data rather than a preset list, you must use group by to get a single instance of each value and also you must use where the text field is not null
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 You skipped John, and your comment is nothing more than a re-hash of what John and I said anyway.

Rehash? I guess you could call additional details a rehash.  Then award your own answer all the points if you think I didn't make a contribution ( i did offer specific suggestions for each combo but that's just details).  I couldn't figure out how to specify point splits thanks to the new close interface.  I didn't think John added anything additional.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Rehash? I guess you could call additional details a rehash. >>

 That's what I'd call it.  You suggested nothing new over the first two comments that I can see, just added more detail.   I covered all the properties except for the Rowsource, which John caught and mentioned.

<<Then award your own answer all the points if you think I didn't make a contribution>>

 Additional details may have been helpful to the asker if it made things clearer to them, but without input from them we don't know that. But at the very least, it should have been an even split.  

 Even so, we really don't know if any of us answered the question.  We think we did (and most likely did as this is a simpler question than most), but we really don't know.

 But this is the very reason Expert's should not be closing their own questions.

 From my viewpoint, lacking input from the asker, the question should simply be deleted.

<< I couldn't figure out how to specify point splits thanks to the new close interface.  >>

 You could have asked.  If the process is un-clear to you as an Expert, or simply not working, then someone needs to know that.

 Note that I will be deleting the question.

Please do not award me any participation points.  You and John divvy them up.  If you are going to take the position that all contributions are equal, then why do manual closes at all?  Just do an automatic close and award participation points to every one and stop bugging me to look at abandoned questions to try to clean them up.  I have enough work to do.

I've looked at my last abandoned question.  If the owner can't be bothered, nether can I.  I'll still get my "participation points" because that's "fair".  Have at it.

PS - if EE hadn't changed the close interface, I would have awarded you the bulk of the points but that no longer seems possible.  You should be annoyed with them, not with me.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
John TsioumprisSoftware & Systems EngineerCommented:
Jim let it go..just split the points with Pat and lets move by me
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.