Form Sorting by wrong key

[Guest]

I have a form based off of a query that uses two primary keys from different
tables (conetype and workorder)

I want it to sort the data in the form by the WorkOrder primary key (unique
#), but for some reason it sorts by the ConeType primary key (also unique).

in the query it correctly sorts by the WorkOrder key. have i missed
something in the design of the form??

 

[Joseph Meehan]

I have a form based off of a query that uses two primary keys from
different tables (conetype and workorder)

I want it to sort the data in the form by the WorkOrder primary key
(unique #), but for some reason it sorts by the ConeType primary key
(also unique).

in the query it correctly sorts by the WorkOrder key. have i missed
something in the design of the form??

How do you have the sort order set in the form?

 

[Guest]

i'm using access 2002 and i honestly couldn't find it.

:

 

[Joseph Meehan]

i'm using access 2002 and i honestly couldn't find it.

:

Open form in design view
Right click on the form
Pick properties
Pick data
Pick sort order.

 

[Guest]

When i open the form properties, there is no "sort order" in the data tab,
there is an "Order by" field, but it does nothing when i put the workorder
field in it.





:


Dia duit

 

[Guest]

ok, nevermind, i figured it out. it was as stupidly simple as selecting the
feild in form view and hitting "sort acsending".

i feel like a tool.

thanks for your help Jason!

 

[Guest]

I mean Joseph!! sorry!

*retreats into hole and hides....*

 

[Joseph Meehan]

I mean Joseph!! sorry!

*retreats into hole and hides....*

:

I have had more than one day like that. Now I am retired and I can just
go back to bed.