Bit thin on information, so I shall make the following assumptions.
In your table of individuals you have a Foreign Key pointing to the Organisation to which the individual belongs.
Your main form is for the individual and you are using a Combo Box to select the appropriate organisation.
The Primary Key for the Organisation table is "OrganisationID" and the foreign key in the Individual table is also "OrganisationID"
The Combo Box is Bound to OrganisationID in the Individual Table.
Having created your subform ("SubOrganisation") based on the organisation, drag it onto the main form and set the LinkMasterFields & LinkChildField to "OrganisationID"
On the After Update of the Combo box, you need to refresh the subform so use something like this
-
Private Sub OrganisationID_AfterUpdate
-
SubOrganisation.Requery
-
End Sub
-
There are other alternatives methods without using a subform as well.
Phil