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?
From the way the question was framed, ie. Printers Old, Printers New, and Assy Parts all in the same table, In order get a list of assembly parts applicable to a specific printer, the table needed a field
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …