Using a form combobox to supply parameter to a query

[rhewitt]

I'm trying to use a combobox on a form to supply a parameter value to a query without any success. I've managed this exact same thing within this database, but for whatever reason it's not working this time.



I have a table 'Species' that contains data relating to many Species-At-Risk. I have a related (1-M) table called 'MajorDrainages' that contains large watersheds where these species are found. I'm trying to supply the DISTINCT values from this related table as the items in the Combobox.

SQL for combobox Row Source:

SELECT DISTINCT MajorDrainages.MajorDrainage
FROM MajorDrainages;

The combobox continues to show up blank on my form. Any suggestions?

[RuralGuy]

If this thread is truly Solved, would you care to share your solution with others that read this Forum?

[rhewitt]

I deleted the combobox, re-created it with the EXACT same SQL statement, and everything is working as expected. I have no explanation as to why it wouldn't work originally.

They say doing the same thing twice, but expecting a different result makes you crazy.

[RuralGuy]

Thank you! That approach works far more often in Access that you would think.