Duplicate Data

[manners]

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???

 

[SteveA]

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

 

[manners]

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!?!

 

[LQ]

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

 

[manners]

Thanks, quite simple really.