Hopefully this is an easy(ish) one for someone... for me it certainly is not.
I've been tasked to make an access (2007) database that will, among other things, allow for a user to choose a single item from an option group on a form. That was easy enough. Then the user will be given a drop down list that is specific to the option selected. For example, the option list has two selections, "fire" and "ice". If the user selects "fire", the adjacent dropdown list will show two options to select from: "match" and "torch". If the user selects "ice", the dropdown list will show: "cube"; "chip"; and "block". Any one of these answers will be filled into the corresponding field in the table. Is this even possible?
I hope I’m making myself clear. Please let me know if not. I’ve searched the forms about IF THEN but am simply too much of a novice just yet (especially with VBA). Thanks.
Thanks! I'll give it a shot. Not being an expert with VBA I don't know if this is relevant (and I probably should have mentioned it before): In my test database I have a table called “elements” (Fire, Ice, etc.) and four tables called “responses”. I want to pull from those established response tables when a selection from the elements table is made.