Query won't alpha Combo Box

G

Gee...

I have 2 tables.

One is a Service Call table with parts, labor, notes, etc, that has the
customer name, address, etc. based the 2nd table, a Customer List table.

I have a form based on a query from the Service Call table with a Combo Box
to choose the customer. When the customer is chosen, the address, etc fills
in automatically.

I've put the Customer List table in alpha order with the button at the top.
I've got it as Sort: Ascending by customer name in the Query but, when you
hit the drop down button on the form, it doesn't alphabetize.

What can I do to get it to alpha?

Thank you in advance for any help.
Gee...
 
D

Douglas J. Steele

You need to use a query with the appropriate ORDER BY clause as the
RowSource for your combobox.
 
G

Gee...

Thanks...can you be more specific?
The Row Source is the query the form is based on.
 
D

Douglas J. Steele

What's the SQL for the query? (If you're not familiar with seeing the SQL,
open the query in design mode, then select SQL View from the View menu. What
I'm asking is that you copy all of the SQL, and paste it into your reply)
 
G

Gee...

Here it is...

SELECT Customertbl.CustName, Customertbl.Address, Customertbl.City,
Customertbl.Zip, Customertbl.LastName, Customertbl.FirstName,
Customertbl.Phone, Customertbl.Fax, Customertbl.Cell, Customertbl.eMail,
Customertbl.SalesRep, Customertbl.State, Customertbl.Notes,
Customertbl.CallNo, Customertbl.Type, Customertbl.Generatedby,
Customertbl.CallContactFirst, Customertbl.CallPhone, Customertbl.CallAddy,
Customertbl.CallCity, Customertbl.CallSt, Customertbl.CallZip,
Customertbl.CallDate, Customertbl.Abstract1, Customertbl.CallContactFirst,
Customertbl.CallPhone, Customertbl.CallContactLast, Customertbl.Terms,
Customertbl.Ground, Customertbl.FedEx, Customertbl.Drop, Customertbl.PONo,
Customertbl.POAmt, Customertbl.Parts1Manuf, Customertbl.Parts2Manuf,
Customertbl.Parts3Manuf, Customertbl.Parts4Manuf, Customertbl.Parts5Manuf,
Customertbl.Parts6Manuf, Customertbl.Parts1Qty, Customertbl.Parts2Qty,
Customertbl.Parts3Qty, Customertbl.Parts4Qty, Customertbl.Parts5Qty,
Customertbl.Parts6Qty, Customertbl.Parts1Discr, Customertbl.Parts2Discr,
Customertbl.Parts3Discr, Customertbl.Parts4Discr, Customertbl.Parts5Discr,
Customertbl.Parts6Discr, Customertbl.Parts1, Customertbl.Parts2,
Customertbl.Parts3, Customertbl.Parts4, Customertbl.Parts5,
Customertbl.Parts6, Customertbl.Parts1Price, Customertbl.Parts2Price,
Customertbl.Parts3Price, Customertbl.Parts4Price, Customertbl.Parts5Price,
Customertbl.Parts6Price, Customertbl.Parts1Notes, Customertbl.Parts2Notes,
Customertbl.Parts3Notes, Customertbl.Parts4Notes, Customertbl.Parts5Notes,
Customertbl.Parts6Notes, Customertbl.EEList, Customertbl.EEEMail,
Customertbl.EEPhone, Customertbl.Manufacturer, Customertbl.EquipmentType,
Customertbl.SerialNo, Customertbl.Billable, Customertbl.Warranty,
Customertbl.Billed, Customertbl.CustomerReq, Customertbl.ActionTaken,
Customertbl.Date1, Customertbl.Hrs1, Customertbl.Tech1, Customertbl.Date2,
Customertbl.Hrs2, Customertbl.Tech2, Customertbl.Date3, Customertbl.Hrs3,
Customertbl.Tech3, Customertbl.TOTALHOURS, Customertbl.Abstract1,
Customertbl.CurrentDate, Customertbl.Date, Customertbl.Days,
Customertbl.CallComp, Customertbl.BODate1, Customertbl.BODate2,
Customertbl.BODate3, Customertbl.BODate4, Customertbl.BODate5,
Customertbl.BODate6, Customertbl.BOTot
FROM Customertbl
WHERE (((Customertbl.Type)="Service"))
ORDER BY Customertbl.CustName, Customertbl.CallNo;
 
D

Douglas J. Steele

And you're using that query for your combobox (even though it's got far more
fields in it than you probably need)?

I can't see any reason why the combo box shouldn't be in CustName order, but
I would suggest using a more tailored query for the combo box's
RecordSource.
 
G

Gee...

Nope, not the query for the combo box but when I looked at the combobox
properties I figured it out: Wrong RowSource...thanks so much!
 
Top