value list

[vlad123]

Hi!
I have a list box with Row Source Type: value list.
I want to delete all duplicates from this list(every value to be found just one time).
Do you have any ideea?

 

[SkipVought]

Hi,

You can use the Data/Advanced Filter - UNIQUE values

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[vlad123]

I am using Access 2003!!!

 

[SkipVought]

Query the table to get distinct values for your list.

Assign the query to the row source

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[vlad123]

the values from this list are not in a table. Just in the list box(value list).

 

[SkipVought]

You'll get a much more directed response in forum702 the Microsoft: Access Modules (VBA Coding) forum.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]