Field lookup.

[maximo1970]

I want to do a lookup on a field that contains the same data multiple times, ie 100,100,100,101,101,101,102,102,102

I want to consolidate the data so I only see the unique data when I do a lookup, ie 100,101,102

Is this possible to do on a form?

 

[Norris68]

You could do, but you wouldn't be able to update anything.

In the RecordSource property, use the DISTINCT keyword. You my need to create a query if you are accessing the table directly. Either enter the keyword within the SQL text i.e. SELECT DISTINCT MyField FROM..., or toggle the Unique Values property in the query properties window.