Access Filter a List Box so no duplicates

I have a query that I am running based on one of the fields in the table.  I don't want to rely on users to enter the date in the correct format so I have it set to create a list box with the values found in the field but since it is a date field, I have many duplicates.  How can I filter the list box values so that each value is only listed one time?

i.e.  Field contains 26-May-09, 26-May-09, 26-May-09, 25-May-09, 25-May-09, 24-May-09

List box would contain:
26-May-09
25-May-09
24-May-09

Thank you.
Melissa-FACAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
Make a query the source of your listbox:

SELECT DISTINCT SomeDate
FROM SomeTable
ORDER BY SomeDate
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Melissa-FACAuthor Commented:
Seems simple enough but.... I have an issue with my field that am trying to search.  When I create the listbox, I select the table and then that one field.  When I advance to the next screen that allows me to set the sort order for the field, it has also pulled the PK into the query.  If I remove the PK from the query, I do not get any results.  If I leave it in, I still have all of the date results (I am guessing because the primary key is distinct).

I am trying to fix a db someone else started.  Is there a way to separate the date field from the PK?

Thanks.
0
Melissa-FACAuthor Commented:
It worked perfectly.  I just had to change the source of my form.  Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.