How to query dynamic field generated on a form in a combo box

[bhuffer]

I have 2 tables (Software_Titles and ITInventory). The software table has (ID, and Title) and the IT Table as (PCID, PCName, 30 some odd software titles in yes/no configuration). Probably not the best setup, but it's what I have. From a "switchboard", I need the ability for users to select a "software" title from a combo box (sourced by Software_Titles table) and find each record in the ITInventory table where a value of True is marked for that particular software title.



Make sense?

[orange]

Your requirement makes sense. This is a fairly common requirement that involves many to many relationships.
However, your database would have
-a Table identifying all PCs involved and
-a Table of all software titles involved and
-a Junction Table identifying which PC has which software titles

Do NOT work with the checkbox apprach -- what happens if you get another 50 or 100 software titles.

There is a data model here showing an IT Asset Inventory (not exactly what you have, but some of the concepts apply)
http://www.databaseanswers.org/data_...sets/index.htm

Review how an IT asset is linked with an Employee

Good luck with your project