I am a Army National Guard Officer trying to build an interim inventory management database solution for the Iraqi Army National Depot here in sunny Iraq. I have used the Northwind Traders DB as s starting point and have done a significant amount of customization. I am an SAP consultant by trade, and my Access skills are a bit rusty. I am using Access 2007.
On the "Orders" form, I turned the "ProductID" in the "Order Details Subform" field into a list box and have the following query pulling the values into it:
SELECT Inventory.[Product ID], Inventory.[Part Description], Inventory.[ANHAM ID], Inventory.[Part Number], Inventory.[Vehicle Class], Inventory.[Qty Available] FROM Inventory ORDER BY Inventory.[Part Description];
I have 2 text boxes in the Order Details form, TextBoxANHAMID and TextBoxPartNumber. I would like the list box to filter the results to what is in the TextBoxANHAMID or the TextBoxPartNumber text box. I've searched all of the forums, but couldn't find a solution.
I attached a screen shot of the form to help you visualize what i'm trying to do.
Thank you for your help in advance, you will be doing a great service to the Iraqi supply system. when we get this up and running, it will help the Iraqi Army the parts they so desperately need much faster.