I have a form with a combo box that lists computer IDs from a table of all the computer IDs, to select focus on a particular computer ID in the subform. I've created a second combo box that can filter the subform's data based upon a different field, OU, in the subform. I want to be able to requery the subform's computer list, based upon the filter by OU, and repopulate the Computer ID combo box.
I thought I could do it by having in the selection query for the combo box's criteria getting its data from the subform's field entries, such as:
Criteria : Like ([Forms]![HIPAA_datasheet subform]![Computer])
as an entry in the computer query of the combo box. The combo box for the computer list is built off of one table, Computers, that is relationally linked to the main HIPAA Table, for popoulating the field for computer IDs in it. When I do this and I select the Computer ID, Access brings up an "Enter Parameter Value" window.