insert value in Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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.
 
Back
Top