sorting problem

[Masoud]

Hello, i have sorted my form in data sheet view with
([qryisometricfilenameA/G].[hypersort]), now i want to save this sorting when
the form will be opened, now when i open the form and sort by another field
and then close that and reopen it, the sorting is by another field that i
have done previous.
My query is like below:

SELECT DISTINCTROW qryisometricfilename.hypersort,
qryisometricfilename.hyper, qryisometricfilename.[Unit No],
qryisometricfilename.[Line Size], qryisometricfilename.[Fluid Code],
qryisometricfilename.[Unit No Iso], qryisometricfilename.[Pipe Sequence No],
qryisometricfilename.[Piping Class], qryisometricfilename.[Insulation Code],
qryisometricfilename.[Total Sheet No], qryisometricfilename.[Issue Date],
qryisometricfilename.[MaxOfIsometric Drawing Rev],
qryisometricfilename.[MaxOfIsometric Drawing List Rev],
qryisometricfilename.[Issued For], qryisometricfilename.Remark,
qryisometricfilename.[DOC No], qryisometricfilename.[line No]
FROM qryisometricfilename
WHERE (((qryisometricfilename.[DOC No]) Like "*001" Or
(qryisometricfilename.[DOC No]) Like "*003"))
ORDER BY qryisometricfilename.hypersort, qryisometricfilename.hyper,
qryisometricfilename.[Unit No], qryisometricfilename.[Line Size],
qryisometricfilename.[Fluid Code], qryisometricfilename.[Unit No Iso],
qryisometricfilename.[Pipe Sequence No], qryisometricfilename.[Piping Class],
qryisometricfilename.[Insulation Code];

thanks in advanced.

 

[Alex Dybenko]

Hi,
you can read form's OrderBy property, save it to some table or registry, and
then set it next time you open the form

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com