97b9ab32445018ea1f489e9dee2120fa The combobox should be able to display the distinct value from the access database but is able to show all the record on the listbox. I tried to select distinct value through wizard but it is not working. So i need some help

Try this

SELECT DISTINCT ColumnName FROM TableName

if does not work, can you post your query.

ok thanks i will try it

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.