I have a problem with the combo box. I have created form, on which I have placed several combo-boxes. I want combo box to use for looking up my records.
I have a table, with many columns. One column have sizes of shoes, those sizes are duplicated. My combo box when opened shows sizes for every record which goes like: 9, 9 ,9 ,8 ,7, ,6, 9 and corresponds to particular record which is useless for search. I want to change it to look like filter so: 6, 7, 8, 9.
I have made query that listed the sizes and removed duplicates, but Im not sure what to do now, I have changed the properties of combo-box but I guess incorectly so Im looking for advice how should I do it correctly. Thank you