insert value in Combo Box

N

nishkrish

How do i input values in combo box where should i input it .
I have customer list which keeps on repeating so i sorted unique records
but dont know where to input data.
 
F

fredg

How do i input values in combo box where should i input it .
I have customer list which keeps on repeating so i sorted unique records
but dont know where to input data.

If your getting your data from a table, and you have a customer name
repeated but you only wish to show that customer once in the combo,
then set the combo rowsource type property to Table/Query.
Set the rowsource to:
Select Distinct CustomerName from CustomerTable Order By CustomerName;

Change the field and table names as needed.

Any reason you didn't look in Access Help?

By the way, if your customer list has repeating customer names, then
your database is not properly normalized. A customer should have only
one record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top