Solved

Combo box question

Posted on 2015-01-29
8
150 Views
Last Modified: 2015-01-29
Hi Experts,
I have a question about combo box on one of my form in Access.  I have a address form that has field name ZipCode and this is a combo box, I do have a table for all the zip code which from 00501 to 99950, but the combox box only show the zip code up to 78552, if user select 80012, it does not show on the drop down.  I have the combo box set up as : Row Source : tblZipCodes,  RowSourceType: Table/Query.  

Thanks,
0
Comment
Question by:urjudo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40577979
re:>  if user select 80012

Q1: How users select a zipcode? Through the combo box?

If so, then the combox box show 80012.

Q2: Does 80012 exists in tblZipCodes?
0
 

Author Comment

by:urjudo
ID: 40577989
Yes, users select a zipcode from the drop down combo box and also the 80012 zip code is existing, but the drop down combox only shows up zipcode to 78552, really have no idea why.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40577991
run this query

select * from  tblZipCodes where zipcode="80012"


see if you get result
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40577996
oh.. it could be a limitation on the number of rows a combo box can show.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 40578002
Comboboxes have a max listcount of ~65k items.  From a UI design standpoint, offering even that many is not providing a good user experience.

How about filtering that list?  For example, if the user enters the state before the zip, requery to have the combobox list only those zip codes applicable to the indicated state.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40578011
see this link for work around

http://allenbrowne.com/ser-32.html
0
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40578048
So, after selection, you need to set combo box to the selected value in the form's underlying table (in current even) like:

Me!ComboboxName = Me!txtSlectedZip

If you do not have Me!txtSlectedZip on your form, then in the control source of your combo box insert field [ZipCode]
0
 

Author Closing Comment

by:urjudo
ID: 40578072
Thanks, I'm going to try it.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 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