Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 155
  • Last Modified:

Combo box question

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
urjudo
Asked:
urjudo
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Mike EghtebasDatabase and Application DeveloperCommented:
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
 
urjudoAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
run this query

select * from  tblZipCodes where zipcode="80012"


see if you get result
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Rey Obrero (Capricorn1)Commented:
oh.. it could be a limitation on the number of rows a combo box can show.
0
 
Patrick MatthewsCommented:
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
 
Rey Obrero (Capricorn1)Commented:
see this link for work around

http://allenbrowne.com/ser-32.html
0
 
Mike EghtebasDatabase and Application DeveloperCommented:
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
 
urjudoAuthor Commented:
Thanks, I'm going to try it.
0

Featured Post

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!

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now