Re: How can I make a combobox show only one instance of a duplicate record
If you have a table, for example, tblCustomers, which for some reason might have duplicate customer records. If there is a unique identifier of a customer in that table, say, CustID column, then write a query
Originally posted by stc834
How can I make a combobox show only one instance of a duplicate record, and hide the rest?
group by CustID
and use it as source for your combobox. The combobox will show CustID's which can be met more than once in the tblCustomers table.
Replies based on my configuration: Windows XP / Microsoft Office Access 2003 unless specified otherwise.