I have looked for this but haven’t been able to get anything to work.

I am trying to use the dropdown “Facility Name” as the criteria to run a query “QBF_Query”. Then “Department” should return the results from QBF_Query.

QBF Query:

Field: Facility
Table: Department Names
Criteria: [Forms]![BCP Document Dashboard]![Facility Name]

Field: Department Name
Table: Department Names

BCP Tracker Form:

Dropdown: Facility Name
Control Source: Table Facility Name
On-change: Run QBF_Macro

Dropdown: Department
Control Source: [QBF_Query]![Department Name]

QBF_Macro

Query Name: QBF_Query
View: Datasheet
Data Mode: Edit

Facility Name Table:

Field: Facility Name (short text)

Department Name Table;

Field: ID
Type: AutoNumber

Field: Facility Name
Type: Short Text
Control: [Facility Name].[Facility Name]

Field: Department Name
Type: Short Text

I tried the above steps and wanted to have the form dropdowns return the results of QBF_Query but it is still returning all results rather than just the results with criteria from Facility Name dropdown.