Filter Multiple Drop Downs

[yrstruly]

I have this join that display theIP OWNER, PLANT ID and Cultivar. For some reason im not geting the selection correct from Plant id.
When i filter on a IP OWner, the dropdown for PlantID, must only show those related. Please VBA update ect.
The problem is:
When I choose an IP Owner from the combo box, the PlantID combo updates correctly, but the other text fields (e.g. Cultivar, Clone, etc.) are not populating. I'm unsure how to correctly bind the other fields (Cultivar, Clone, IP Number) to populate based on the PlantID selection after filtering by IP Owner.

SELECT

    TblLicence.PlantID,

    Plants.Cultivar,

    Plants.Clone,

    TblLicence.Nr AS IP_Number,

    Profile.Display AS IPOwner

FROM

    (TblLicence

        INNER JOIN Plants ON TblLicence.PlantID = Plants.PlantID)

        INNER JOIN Profile ON TblLicence.Nr = Profile.Nr;

PlantID	Cultivar	Clone	IP_Number	IPOwner
Ab0075	Goldenl.REINDERS®	I 7930	761	NAKo

[Welshgasman]

Bring in the data with plantid and in the after update of that, set your textboxes.

[Gicu]

You could add the Cultivar, Clone, IP Number to the PlantID row source then simply use them as the control sources for the textboxes like in =[PlantID].Column(1) (this would be the second column of the row source).
Cheers,