Removing Duplicate Data in a Drop Down

[KW99]

Hi Wondering if anyone can help.

I have a form, which is set up so that the user can select the search criteria from drop downs. The problem is I would like the date drop down to only allow the user to select an available date from a table of data hence I have linked the date dropdown to the table data.

Here is where the problem is:

I have duplicate dates for various bits of information stored in the table and when it is linked to the form dop down I will obviously get say 10 lots of 01/01/2009 and 7 lots of 02/03/2009 etc..etc.

Is there any way to filter out the duplicates in the form dropdown or is there another way i.e. to do query on the table data and have that feed into the form drop down or something. I just want one date for each available date instead of multiples.

Thanks in advance

 

[pbaldy]

Try a rowsource of

SELECT DISTINCT FieldName FROM TableName

 

[KW99]

Wonderful.....worked like a charm!!!

Thanks for your help.