Thank you for your post. I haven't tried resetting the record source based on the users selection as in your sample. My VBA skills are lacking but I think the example might help. Unfortunately I don't see a way to eliminate the first step as there are hundreds of projects, each having as many as...
I have spent almost two weeks and countless hours trying to make this work and am ready to give up. I really need some help.
I have a form that needs to load with all controls null. The user then chooses a project number from an unbound combo box. This selection populates an unbound list box...