Alpha Order for look up query

[Amanda]

Hello,
I am using a query as my look up for a field on a form. My problem is it
will not go in alphabetical order. The original table the information comes
from is in alpha order, as is the query...but it will not come that way into
the form.

Any suggestions?

 

[Arvin Meyer [MVP]]

Do not rely on a sort done by clicking on the column in the query and
sorting by it. Make sure the query has an Order By clause.

 

[Larry Daugherty]

As asked, your question confuses me. Please post back with a more
complete description of what you are trying to accomplish.