Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by r6rh

  1. r6rh

    Cascading Combobox code to update multiple combo boxes

    Ok I figured out the syntax. Now I'm having problems getting the code to run in the right event. I tried using the forms_afterupdate() but it runs the code after you press save. Is their a event that I could use that would trigger after a user enters/changes anything on the form?
  2. r6rh

    Cascading Combobox code to update multiple combo boxes

    I think I've conceptually figured it out with your hints. I just need help with the syntax. In my Select Case writing am I writing the "then" statement correctly? I'm getting a compiler error and it is trying to find a list separator or). Below is the exact code I am using with. Thank you...
  3. r6rh

    Cascading Combobox code to update multiple combo boxes

    I understand all the code inside which would be inside the loop. I attached an example I found that is very similar. http://fontstuff.com/access/acctut10.htm I could go and do this 12 times but it would be a pain in the butt to edit down the road. I want to learn how to make the code simple...
  4. r6rh

    Cascading Combobox code to update multiple combo boxes

    I am looking for some help in my custom Access Database. I have 24 cascading combo boxes (12 independent and 12 dependent/cascading) that I would like to code in one place to keep it nice and neat so in future I can easily edit it. I have had some responses to use a sub / function to do...

Part and Inventory Search

Back
Top