A-Z Sorting Combo

  • Thread starter Thread starter Ron A.
  • Start date Start date
R

Ron A.

Hello...I have a combo box in a form that looks up a value in a table. I was
wondering if it is possible to sort the displayed combo box values
alphabetically? Row source is:

SELECT tblVendors.VendorID, tblVendors.Vendor FROM tblVendors;
 
Ron

Open the query in design view.

Under the [Vendor] field, select "Ascending" in the Sort 'cell'.

(that assumes that [Vendor] holds the alphabetic text you want sorted)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks guys.
--
Aloha,
Ron A.


Steve said:
Make a query based on TblVendors and sort the Vendor field. Use the query as
the rowsource of your combobox.

Steve
(e-mail address removed)
Click to expand...
 
Back
Top