Sort not holding in form combined field (1 Viewer)

[Tina49]

I have a field on a form called ChemID. This field is made up of two fields, ChemID and ChemName. Only ChemName is displayed. I have a query assoicated with the form that sorts by ChemName; however, the form always displays the original sort of ChemID. Any help would be appreciated. Here is the query

SELECT Chemicals.ChemID, Chemicals.ChemName FROM Chemicals
UNION
SELECT Chemicals.ChemID, Chemicals.AltName1 FROM Chemicals WHERE Chemicals.AltName1 IS NOT NULL
UNION SELECT Chemicals.ChemID, Chemicals.AltName2 FROM Chemicals WHERE Chemicals.AltName2 IS NOT NULL
ORDER BY Chemicals.ChemName;

 

[Galaxiom]

Check the form properties. It may have an OrderBy and OrderByOnLoad applied there.

 

[Tina49]

Yes, I had already set that, but it does not seem to make a difference.

 

[vbaInet]

Does it show the right sort order when run as a query?

Are you opening the form in Datasheet or Continuous View?

 

[Tina49]

Yes, the query runs just fine. Running in form view.

 

[vbaInet]

Rather odd huh!

Can we see your db?