Solved

MS Access 2003 AfterUpdate on drop down text box

Posted on 2008-06-13
9
159 Views
Last Modified: 2010-08-05
Capricorn,

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?
0
Comment
Question by:deer777
  • 5
  • 4
9 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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.
0
 

Author Comment

by:deer777
Comment Utility
I will have to wait until later this evening to send you a sample of what I need.  Thanks for all your help!
0
 

Author Comment

by:deer777
Comment Utility
Capricorn1,

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?
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
can you post sample data, all variations...
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:deer777
Comment Utility
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?
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
are you referring to a different drop down box (other than cboMarket ,cboID)?
0
 

Author Comment

by:deer777
Comment Utility
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?
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
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()
me.cboID.dropdown

end sub

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



0
 

Author Comment

by:deer777
Comment Utility
Capricorn1

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!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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.

772 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

10 Experts available now in Live!

Get 1:1 Help Now