For this example, let's say that your table name is CUST, and the field you are using would be CustNameI'm trying to create a combo box for users to select data for a query however the field that I'm using has multiple records which use the same data. When I create the combo the drop down shows the data repeated for each record. For example, I want to be able to look up all records for the same surname but when I look up Smith the combo box shows this name repeated several times. How can I set this so that it only shows a list of different names?
in the properties of your combo box, on the Data Tab, under rowsource put the following:
SELECT [CUST].[CUSTNAME] FROM CUST GROUP BY [CUST].[CUSTNAME] ORDER BY [CUST].[CUSTNAME]
let me know if this helps you.