Trouble populating dropdown in form via expression builder

[Guest]

I have a form that has what hopefully will become several dropdowns. The
choices for the dropdown should be all DISTINCT results from a set of query
results for a field. For example, this dropdown should be able to list all
the different Project values that meet a certain date timeframe. I am using
expression builder to populate the dropdown. The problem I am having is I
seem to only get a single instance of one Project, rather than a dropdown
list. I know the query returns more than one value for Project. I probably
have the reference pointing too deeply in the tree. Can't figure out
expression builder on how to do this. Any advice helpful, thank you.

 

[Guest]

I figured this out, deleted the form, added a combobox from scratch. Presto,
there's a wizard that helps out. It is important to say "no" to "base this
form on a query" if it's too hard to customize the results. Better build each
combobox from scratch.

Thanks!