Combobox Unique Values Still Showing Duplicates

[PicoTTS]

Hi,

I have 4 unbound comboboxes that i have populated with information from a query. I would like them to be used a way to help filter the subform I have on the form. I have set all the comboboxes to show only unique values, however, I am still getting some duplicates.

I am pretty sure it has something to do with the way I have setup my row source. For example, I have 1 of my roww sources setup to be also dependent upon the 3 other comboboxes as such:
[Forms]![Overview]![Product] Or [Forms]![Overview]![Product] is Null
[Forms]![Overview]![City] Or [Forms]![Overview]![City] is Null
[Forms]![Overview]![Customer] Or [Forms]![Overview]![Customer] is Null

I set it up this way because sometimes I only want to use 2 of the comboboxes to filter and still show all possibilities for the unused filtered criteria.

[CJ_London]

OK - so you think it has something to do with your rowsource. Looking hard, but can't see it so not sure what to suggest

[orange]

Seems you are telling us HOW you did something and it isn't working as expected.
For readers to offer focused suggestions, they/we need to know WHAT you were trying to accomplish.
Just a plain English description - so we can understand WHAT your approach is "solving/trying to solve".

[PicoTTS]

Basically, I just wanted to create 4 unbound combo boxes and use them to filter a sub form i have on my form. The combobox lists should be coming from another table that may include multiple duplicates values within a field. I only want my filter lists to be show 1 instance (unique) Value. If any of the 4 unbound comboboxes are left empty, then hte subform should consider that field unfiltered and show all the data for that criteria. Sorry if it was unclear.

[orange]

You may get some ideas from this free video by Steve Bishop.
You might also post a copy of the database --remove anything private first, then zip and attach to POST.

[Homegrownandy]

If table 1 has two related record in table 2 and you are using both tables as a source of information. Then to show tables 2 information details from table 1 must appear twice.

If thats how you are asking the database for information, thats how you will get it.

[orange]

Still not following these:

I only want to use 2 of the comboboxes to filter and still show all possibilities for the unused filtered criteria.

If any of the 4 unbound comboboxes are left empty, then hte subform should consider that field unfiltered and show all the data for that criteria. Sorry if it was unclear.