Filter Of Drop Down Slelection

[yrstruly]

I want to select IP OWNERS, from a drop down, and relalted Cultivars must then load. Cultivars does not load.
Please see sample data an form.

https://drive.google.com/file/d/1hqb...ew?usp=sharing


https://docs.google.com/document/d/1...f=true&sd=true

SELECT DISTINCT Plants.CultivarFROM Plants
LEFT JOIN Profile AS Profile_Display ON Plants.IPOwner = Profile_Display.Nr
WHERE Profile_Display.Display = Forms![Form_Plant Evaluation]!cboIPOwner
ORDER BY Plants.Cultivar;

[CJ_London]

not prepared to download from google, only uploaded files. remove forms/reports/tables/queries not relevant to your question, compact then zip using the upload facility (click on the go advanced button at the bottom of the window)

[June7]

What you describe is cascading or dependent combobox/listbox - common topic.

Code needs to Requery the second combobox or set its RecordSource property. Post your code behind Owners.

Why is Cultivars combobox a query that joins tables? Why is Query missing a space in front of FROM?

If you want to provide files, follow instructions at bottom of my post.

[yrstruly]

Thank you for the assistance. To get he IP Owner's name with their rspective IP Owners code, two tables are joined. Thats why Cultivars is a query that joins.

SELECT     Plants.PlantID,
    Plants.Cultivar,
    Plants.IPOwner,
    Profile_Display.Display AS [IP Eienaar],
    TblLicence.ConType,
    TblLicence.Renewable
FROM 
    (TblLicence
    LEFT JOIN Plants ON TblLicence.PlantID = Plants.PlantID)
    LEFT JOIN Profile AS Profile_Display ON Plants.IPOwner = Profile_Display.Nr;