MS Access 2003 AfterUpdate on drop down text box

Posted on 2008-06-13
Last Modified: 2010-08-05

I just got different information regarding the drop downs we just spoke about.  

the first combo box is cboMarket which I select South, Central, West.  After doing the selection I would like the next combo box which is cboID (it contains numbers beginning with various initials specific to market in some instances several initials per market) how could I  sync up depending on the Market that I choose in the after update   How could I accomplish this?
Question by:deer777
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
  • 5
  • 4
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 21782015
now you have to attach your db, looks like you have incosistent data format.

check the attach file below. do a compact and repair first. if db is >4mb zipped it.

Author Comment

ID: 21782053
I will have to wait until later this evening to send you a sample of what I need.  Thanks for all your help!

Author Comment

ID: 21782449

What if we could allow the user to input the first two characters of the number within the drop down list and have it automatically filter off that information.  Is that possible?
Technology Partners: 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: 21782666
can you post sample data, all variations...

Author Comment

ID: 21782786
OK my drop down text box on my form has several variations of numbers in the list

ex. AL0123, KY123, TX0123.

I want to be able to tab to that drop down text box and enter AL to filter only the numbers beginning with AL  or KY if I entered KY from my drop down list.  Is this possible?
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 21782933
are you referring to a different drop down box (other than cboMarket ,cboID)?

Author Comment

ID: 21783002
only cboID . . . so I will tab from cboMarket to cbo ID and I want to filter the drop down list by several characters I input in the text box to filter out only those numbers which begin with those characters I have typed in.  Can we do this that way?
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 500 total points
ID: 21783044
wait.. i thought that the value selected from cbomarket is related to the items in cboID.

can you post the data from the table where you are getting the values as rowsource of the combo box.

<I want to filter the drop down list by several characters I input in the text box to filter out only those numbers which begin with those characters I have typed in.> this is one of the property of combo boxes.
try this with this code in the enter or click event of the combo

private sub cboID_enter()

end sub

now type the letters and the combo will automatically move to the list starting with the letters you typed.


Author Comment

ID: 21783591

I have gone home for the evening but will try this out in the morning.  Thank you for all your help.  i have no doubt that this code will work perfectly.  Thanks much!  You're the best and it shows!

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

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…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

749 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