Hello Everyone,
I am stuck in a problem for many days now.
In the form, on which I am working, there are 2 dropdown lists (combo box).
The data in the first combo is coming from a list and in the second combo, I am running a query, and depending upon the selection in the first combo, the data in the second combo may come from one of many tables in the database.
What I want is to have control over the data, before it is being displayed in the second combo, as the data in have many null and 'same name' entries. But what I don't want is to change the original data in the tables.

Till now, I have been trying to make use of persistant recordset, that is, by storing the recordset in an external table, changing its data and binding it to the second combo. But I am unable to bind the data.

What in your opinion, is the best approach to accomplish this. A snippet will be of great help as I am not a experienced programmer.

regards

Hi,

   Open the query for the second combo box and use SELECT DISTINCT to select distinct values in your look up column. THis should work. I made a Table called Table1, populated it with many duplicate values, and then wrote this query, which only comes up with one entry for each value, thus removing duplicates:

SELECT DISTINCT Table1.Value
FROM Table1;

   You may have a problem if your combo box is binding to another column.

HTH


mmcdonal