Limiting entries in a combo box

[brian0721]

I'm full of questions today..

Okay, I have a combo box that returns the loan officers assigned to each mortgage. However, it returns the same person over and over again for each entry. I just want each name to appear once in the combo box?


Thanks again!

 

[dcx693]

What is the rowsource for the combo box? If it's a table, you need to instead, create a query that pulls unique names from the table, then base the combo box on that new query. If the rowsource is a query, then edit it to make sure it pulls unique names only. How? Open the query in design view, if the Properties sheet isn't visible go to the View menu, choose Properties to make it visible (and make sure it says "Query properties" in the title bar - if it doesn't then click on the the grey area near where your tables are shown), then Set the Unique Values property to Yes.