Solved

Combo box question

Posted on 2015-01-29
8
145 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
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 33

Expert Comment

by:Mike Eghtebas
Comment Utility
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
Comment Utility
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 119

Expert Comment

by:Rey Obrero
Comment Utility
run this query

select * from  tblZipCodes where zipcode="80012"


see if you get result
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
oh.. it could be a limitation on the number of rows a combo box can show.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
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 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
see this link for work around

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

Expert Comment

by:Mike Eghtebas
Comment Utility
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
Comment Utility
Thanks, I'm going to try it.
0

Featured Post

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.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

771 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

15 Experts available now in Live!

Get 1:1 Help Now