Create form to filter / view only rows that match a specific word in a field
Windows 8 
Access 2013
I have a table that needs to be updated by different stakeholders. Each person has their own product code. The product code itself repeats, but the related information is different in each row.
They are not tech savvy (nor am I, much). Instead of creating a table for each product code (that would be far too many in reality) and having to perform a union query, I would like to create one table, and then a form that allows them to filter by product code so only the content relevant to them is visible.
From there, they can edit existing information, or add additional fields.
If I’m not being clear, here is an example of what the table looks like:
Product Code Description Region
AAA Short NA
AAA Wide NA
AAA Prickly EU
BBB Soft NA
BBB Tall ASIA
CCC Lanky NA
CCC Red EU
CCC Fat NA
CCC Thin EU
How can I make a form, and perhaps some sort of combo box, that will allow a user to select “CCC” so only the 4 CCC rows show up? From there, I want them to be able to edit existing records or add new ones. Once saved, it will add to the master table.
Many thanks!
If there are suggestions for a better way to manage content updates from multiple sources who are non techy users, I would welcome those, as well!
Reply With Quote
