G
Ginny
I have a form with a drop down lists of names that are in the Sponsor Name
field of my table. I have the Row Source type is set to Table/Query and the
Row Source is set to:
SELECT [Games of Chance - Master Table].[Sponsor's Name] FROM [Games of
Chance - Master Table] ORDER BY [Sponsor's Name];
I use this to help with the data entry, but several records have the same
name, so the same name is listed multiple times in the drop down list, how
can I remove the duplicates from the drop down list?
field of my table. I have the Row Source type is set to Table/Query and the
Row Source is set to:
SELECT [Games of Chance - Master Table].[Sponsor's Name] FROM [Games of
Chance - Master Table] ORDER BY [Sponsor's Name];
I use this to help with the data entry, but several records have the same
name, so the same name is listed multiple times in the drop down list, how
can I remove the duplicates from the drop down list?