Hi,
I have a combo box acting as a filter for a form which contains data from 2 seperate fields using the following SQL code:
SELECT tblData.Field1 FROM tblData GROUP BY tblData.Field1 UNION SELECT tblData.Field2 FROM tblData GROUP BY tblData.Field2;
This combo box works fine in showing the...