MS Access 2003 AfterUpdate on drop down text box

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?
deer777Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
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
 
deer777Author Commented:
I will have to wait until later this evening to send you a sample of what I need.  Thanks for all your help!
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
deer777Author Commented:
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
 
Rey Obrero (Capricorn1)Commented:
can you post sample data, all variations...
0
 
deer777Author Commented:
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
 
Rey Obrero (Capricorn1)Commented:
are you referring to a different drop down box (other than cboMarket ,cboID)?
0
 
deer777Author Commented:
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
 
deer777Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.