I have a table named "Categories". I have a field named "Method" in that table. I would like to display unique values from the said field in a combobox. To test this out, I created a blank form, added the combobox, went into the Query Builder form, set "Unique Values" from the Query properties to Yes. I then ran the query and everything displays just the way I want it. I then save changes to the combobox but when I go to Form view the combobox is empty.
I checked the row source and true to form it says SELECT DISTINCT Categories.Method FROM Categories...so why then does this only work when I run the query but not for the combobox?
I must have been playing around with this for hours to no avail. I find that when I follow this process on an existing query instead of a table it works just fine with the combobox - it just doesn't seem to work with a table. Any ideas what I could be doing wrong?