Hello,
I'm working on a form that has a cascading list. My first list has 3 categories (vendors, subcontractor and customers). My second list has the names of either of them depending on what I choose from the first list. The trouble I'm having is that when I switch to thru the first list, my second list doesn't go blank as i would like it to. Instead it keeps the previous info from what i chose before it.
For example: In the form attached, I clicked on VENDORS on cell J3 and I got Home Depot on cell E6. When I switch to another category in J3, Home Depot in cell D6 doesn't go away. How do I fix this?
Thank you so much.
Bookmarks