Form Sorting by wrong key

D

Dale

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??
 
D

Dale

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
 
D

Dale

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!
 
Top