Hi I have 12 comboboxes for data entry. Everytime I type in some input in the form, it gets stored in the Access Database.
Every time my form loads, it picks up all distinct values from the database and fills the combo box. But there are several repeated values because the data that i entered through the form gets entered without proper alignment in the DB and hence the combo box is loaded with values..
I am not sure how I am supposed to get rid of this problem !