I have created a search menu with a drop down list of all data for a particular field from records i've entered. However some data is duplicated and I wish to have just one occurence of this.

Can anyone point me in the right direction please???

If the source of your dropdown box is a query, set the 'Unique Values' to 'Yes' in the Properties of the actual query. This will ensure that duplicated entries are removed.

Cheers,
SteveA

My search is actually based on a table, so the "Unique Value" property is not available.

The field I am searching on has many different records associated with it so its not the table values that need to be unique, just the drop down list based on the table...

anyone!?!

If your source is a table, then in the properties for the combobox, next to row source, you can type in something like:

select DISTINCT yourtblname.yourfieldname from [yourtblname]

This will pull unique values from the field where your info is coming from.

HTH

Thanks, quite simple really.