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?

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Amanda" <(E-Mail Removed)> wrote in message
news:6907E920-98F9-49AC-A37E-(E-Mail Removed)...
> 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?
>
>

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

--
-Larry-
--

"Amanda" <(E-Mail Removed)> wrote in message
news:6907E920-98F9-49AC-A37E-(E-Mail Removed)...
> 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?
>
>