Alright, in my Database I have many samples that are frozen on different dates.
What I'm trying to do is create a combo box with all the dates included. And when a date is selected, display all the samples that were frozen on that date in a listbox.
However, I've run into a problem already in that when I choose to make the combo box from the date column of my table, it takes all the dates, even the duplicates. For example, if there are 3 samples frozen on june 20th. there will be 3 june 20th's in the combo box. How can I get rid of this. I tried the removeitem property but it's not working. It says I'm not able to use this property when the combo box is connected to a data table or something when I go to help. ANY SUGGESTIONS?
Thanks.
What I'm trying to do is create a combo box with all the dates included. And when a date is selected, display all the samples that were frozen on that date in a listbox.
However, I've run into a problem already in that when I choose to make the combo box from the date column of my table, it takes all the dates, even the duplicates. For example, if there are 3 samples frozen on june 20th. there will be 3 june 20th's in the combo box. How can I get rid of this. I tried the removeitem property but it's not working. It says I'm not able to use this property when the combo box is connected to a data table or something when I go to help. ANY SUGGESTIONS?
Thanks.