Removing Duplicates from Drop Down Menus

[Dan T]

Hello everyone. First post and new to this forum.



I am a complete noob to access. Fast learner trying my own project.

I have an issue with duplicates not being removed from my drop down menus.

I have tried several things to remove them that i have found around numerous places online.

The "Distinct" formula appears to not work for me,

SELECT DISTINCT [Data Spread].ID, [Data Spread].Make FROM [Data Spread];

Have Tried by creating a query and having the drop down linked to it.

SELECT DISTINCT [Data Spread].Make, [Data Spread].ModelFROM [Data Spread]
ORDER BY [Data Spread].Make, [Data Spread].Model;

Also tried the "Unique Values" setting, This too is not working for me,


Any ideas where to go from here or what i can do to assist you assist me.

Kind Regards
Dan

[Dan T]

Also... Once this is sorted i will be linking the results of this drop down menu to determine what the next drop down will have to offer, This step will be carried over about 6 times. Is there an easy process for this to be completed?
The next menus will be labeled,
Model,
Engine Type
Transmission
Drive
Year
Service Type.

If this can be integrated into the assistance from the first question, it will assist immensely.

Cheers

[CJ_London]

select distinct does eliminate duplicates, but you have included ID which is unique to each record....

if you need the ID , then you need to store make and ID's in a separate table

[Dan T]

Ajax, Thank you for your reply, Unfortunately i am a complete Noob, and i apologize, i do not understand what you mean nor how to fix it.

[CJ_London]

try

SELECT DISTINCT [Data Spread].Make FROM [Data Spread];

[Dan T]

That is now returning a blank drop down.

Ive tried uploading the file for reference but it is a tad too big.

[rpeare]

run the query that ajax suggested in a query window, I can pretty much guarantee it returns values. It is more likely that your combo box has multiple columns and you have suppressed the first column, where ajax's query only returns one value (in the suppressed field) so you can't see it. Try making your first column of your combo box a width greater than zero.

[Dan T]

Thankyou very much, has worked as suggested, Have managed to work out how to use queries and a few other wizards which is making things alot easier for me and have taken that avenue instead. Thank you very much for your input, as much as i am not using this method any more, i have now learnt for the future if i was to come across this issue again.