How to Sort record while bringing back on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I've form which I'm using for new input and for edit too, this form consist
of srlNo field where i m writng transction nos like 1 2 3 and soon. This
form is based on recordset
strSQL = "SELECT * FROM [DataSub]WHERE DocumentNo =" & DocumentNo & ";"

Me.RecordSource = strSQL
my problem is while briging back the record I want the records must appear
in sequence like 1,2,3 but now im geting 1,3,2 any help
thanks in advance.
 
Hi

Is this not what you want?:

strSQL = "SELECT * FROM [DataSub] WHERE DocumentNo =" & DocumentNo & " ORDER
BY [srlNo];"
 
Thank you very much Mr. David , It works - exactly Wahat I want and job done
too!

David Cleave said:
Hi

Is this not what you want?:

strSQL = "SELECT * FROM [DataSub] WHERE DocumentNo =" & DocumentNo & " ORDER
BY [srlNo];"



Wahab said:
Hi
I've form which I'm using for new input and for edit too, this form consist
of srlNo field where i m writng transction nos like 1 2 3 and soon. This
form is based on recordset
strSQL = "SELECT * FROM [DataSub]WHERE DocumentNo =" & DocumentNo & ";"

Me.RecordSource = strSQL
my problem is while briging back the record I want the records must appear
in sequence like 1,2,3 but now im geting 1,3,2 any help
thanks in advance.
Click to expand...
Click to expand...
 
Back
Top