Search results for query: *

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?

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...

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...

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...