This [SELECTDISTINCT is 2 separate words - SELECT DISTINCT. Does Access put square brackets around your code?
Anyway, suggest you develop your sql in query design view and test, as a rule, then adapt to your control rowsource. However,
- you cannot use ME reference in query design. It would have to be Forms!myFormName.MyControlName or a valid value.
- AFAIK, you cannot use ME reference when creating a rowsource for a control; not even like =' & Me.myControlName & '; These types of references are used in code.
- or you can create and save such a query, using the Forms! reference, then set the rowsource to that query name. The caveat is that the form must be open in form view, and the referenced control would have to contain a value for the query to work as expected.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.