I'm back! (Not that I really ever go away at this point).
With some help of a developer friend of mine, I have made a slightly complicated set of sub-forms (at least in my eyes).
On this form, I have the left List Box which is just a typical list box bound to a table to show my applications list of contractors. When you select a contractor from the left list box and click the button, some VBA runs and moves the value to the right list box. For testing purposes, the two boxes before the left list box just show the ID of the selected contractor in the right list box.
Those items work wonderfully (minus the fact I need to make a button to remove items from the right list box). When you select a item from the right box, the ID appears in the box below showing that it is "holding" the ID of that contractor. You can then select a value from the combobox and enter a quantity which then populates in the queries sub form.
As you can see in the picture, the query shows everything entered regardless of what is selected (I know nothing is selected in the picture). How can I get the query or its sub form to filter so it only shows the selected contractor/ID's items? I would like it to show everything for the selected, or be blank. I think showing everything at any time could potentially confuse my users.
With some help of a developer friend of mine, I have made a slightly complicated set of sub-forms (at least in my eyes).
On this form, I have the left List Box which is just a typical list box bound to a table to show my applications list of contractors. When you select a contractor from the left list box and click the button, some VBA runs and moves the value to the right list box. For testing purposes, the two boxes before the left list box just show the ID of the selected contractor in the right list box.
Those items work wonderfully (minus the fact I need to make a button to remove items from the right list box). When you select a item from the right box, the ID appears in the box below showing that it is "holding" the ID of that contractor. You can then select a value from the combobox and enter a quantity which then populates in the queries sub form.
As you can see in the picture, the query shows everything entered regardless of what is selected (I know nothing is selected in the picture). How can I get the query or its sub form to filter so it only shows the selected contractor/ID's items? I would like it to show everything for the selected, or be blank. I think showing everything at any time could potentially confuse my users.