I have a form where I can add a new Company to a Table in the database. In addition to Company name, location, etc, the form has a Combo box where I can select a company's sector from a list. I then can select a subsector also.
Once I've selected a sector, I want to the subsector list to update to all the possible choices of subsectors FOR THAT SECTOR currently in my table.
Currently I'm using this:
SELECT [Table: Companies].[Subsector] FROM [Table: Companies] GROUP BY [Table: Companies].[Subsector] ORDER BY [Table: Companies].[Subsector];
which just lists all possible subsectors for all sectors currently in the table.
How do I edit this to includes only those subsectors based on my sector choice.
thanks.
Once I've selected a sector, I want to the subsector list to update to all the possible choices of subsectors FOR THAT SECTOR currently in my table.
Currently I'm using this:
SELECT [Table: Companies].[Subsector] FROM [Table: Companies] GROUP BY [Table: Companies].[Subsector] ORDER BY [Table: Companies].[Subsector];
which just lists all possible subsectors for all sectors currently in the table.
How do I edit this to includes only those subsectors based on my sector choice.
thanks.
Facebook
Twitter