A-Z Sorting Combo

[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;

 

[Jeff Boyce]

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

 

[Ron A.]

Thanks guys.
--
Aloha,
Ron A.

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

Steve
[email protected]