Question MS Access:How to split values in a cell and list them down (1 Viewer)

Hi,

I need you help...I am doing my Final Year Project now...
My database has a table call "Data", inside the table there are 2 fields-"Supplier" and "Product". The string value in product column is comma separated (Shown Below).
Product
1 HOSE, FITTINGS
2 GENERAL HARDWARE
3
4 IC CHIPS, CONNECTOR
5 GENERAL HARDWARE
6
....
The rows of this column is unlimited and product is updating. I need to get all the products (values) in the column and filter duplicated values (like 2 and 5) and skip blank row (like 3)...But the question is inside a row, there may be more than one product separated by comma. Can help me how the get the comma separated value and list down in a table (Query?Module?Macro?)?
Expected result:
Product
1 HOSE
2 GENERAL HARDWARE
3 FITTINGS
4 IC CHIPS
5 CONNECTOR
....
after that, the values should be added to a combo box allow user to choose.
And I think there should be a loop function to scan the whole column so to get the products...

Will be appreciate for your reply....

Please refrain from posting the same thing multiple times. Future instances of this will be considered SPAMming along with the application of all attendant penalties.

I will be locking all other threads.

I have un-deleted this thread ans there is a locked thread that refers to it.