MightyRavendark
MightyRavendark

Reputation: 33

MS Access: Filter combobox entries by value from parent form

I want to create a subform in Microsoft Access where a dropdown contains values filtered by a value from the parent form. The data model looks like this:

Data Model

A facility can have multiple buildings containing multiple machines. Service teams of a facility look after this machines. The desired form looks like this:

enter image description here

My question is how to filter the combobox shown in the above screenshot so it only shows service teams belonging to the same facility as the machine they are going to be assigned to? I want to do this - if possible - without any VBA coding, just using the frontend editor tools built in access.

Upvotes: 0

Views: 52

Answers (0)

Related Questions