Greetings all,
Using 2007 for a project at work. Here is what I have:
- Set up of tables that flow Division -> Branch - > Missions - > Projects -> Updates
- Form that inputs worker updates into the Update table. This is working just fine.
- Form that I use for Management to output the Update information based upon a DATE RANGE and the DIVISION or BRANCHES.
- There are multiple Branches in the Division
- I have the form feeding a Query that has a criteria for the input date. This is also working fine.
*** My problem is in selecting the Branch. I have a combo box that works just fine but can only select a single Branch. But I need the ability to select multiple Branches. I have tried a list box but it wont feed the query properly for some reason. I have tried everything I can think of to make this work, but am out of ideas.
Any assistance would be greatly appreciated. Thank you!