How do you get listed drop down items to appear in Access 2003 file when they don't for some reason?

In working with Access 2003, the drop down menu that lists items needed for a company's ordering process shows no information that the client can choose from.    The following attached filed is an example of what we are trying to explain.
Accounts-Without-Names.rtf
memewarrenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

PatHartmanCommented:
The site doesn't handle .rtf format.  It won't let me download the file and opening it shows gibberish.  Please try again.  Either post a picture or a spreadsheet or .doc file.
0
memewarrenAuthor Commented:
OK Will do.
0
John TsioumprisSoftware & Systems EngineerCommented:
When you have a drop down (combobox) you set it up like this
Data Tab
RowSourceType :Table/Query
RowSource : Your underlying Query
BoundColumn : The Column that actual  is used for the field (the key)

Format Tab:
Column Widths :0cm;3cm;5cm  (the important is the 0 zero ---> we hide the key and we are showing the info we want to display regardless of the fact that column 1 is going to be stored in our record . The others correspond to the info we want to show : e.g RowSource was something like SELECT CompanyID,CompanyAbbreviation,CompanyName from Companies --> the combobox will display for a Company with data :  CompanyID = 1, CompanyAbbreviation = "TST",CompanyName = "Test Company" ====> TST | Test Company
List Width : 8 cm (3+5)
Try that and let us know...

P.S. for those having issue with the attachement Right Click --> Save linked Content as
0

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
memewarrenAuthor Commented:
I was told that I need to send this in a different format than *.rtf, so here is the image in a *.pdf format.
Accounts-Without-Names.pdf
0
PatHartmanCommented:
Thanks but you already had your answer.
0
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
Microsoft Access

From novice to tech pro — start learning today.