quick question re rowsource, rowsourcetype field

[MForrest]

I want to display the data from a field within a table to my combobox, but the data in this field is not unique. Is there a quick fix to remove the duplicates by displaying only the unique occurances within my data field?

Originally I did list the values, but the user has a utility to ammend, add or delete the data within this field, so want the corresponding data in my combobox to reflect any changes.

 

[aprogrammer]

you could try to make for example a cursor (SELECT DISTINCT yourtable.yournotuniquefield FROM yourtable INTO CURSOR cursorforcombo) and then set the rowsource to be this cursor.

 

[MForrest]

That works a treat thank you!