Using a combo box to query fields within a table in MS Access 2003
Posted on 2008-06-17
What I'm trying to do is have a combo box drop down a list of parts from my 'Item' table in Access 2003. This list will be filtered by the 'Class' that each item is, specifically trying to show Printers ONLY, and have this list be in ascending order. The Class types that would be triggered by the 'LIKE' command are NEW PRINTER and OLD PRINTER. So I 'figure LIKE %printer' would do. Eventually, I would like this combo box to drop down and filter JUST the printers from the 'Item' table, so when I clicked on any printer I would have let's say 10 or so text boxes associated with that printer to show the part numbers in each text box making up the parts of that given printer. The parts are in the 'Item' table as well, under 'Class' ASSY PARTS
All in all, this is how I would like the combo box to function.
Can anyone help me fix this issue in my combo box so that I may click a printer from my drop-down box, and have its associated parts displayed in text boxes below the combo?