Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Combo box question

Posted on 2015-01-29
8
Medium Priority
?
154 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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 93

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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

722 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