Sorting records in continuous subform

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

Guest

I have:

Mainform
Subform 1
Subform 2 (continuos form I want sorted)

I have set Subform2 OrderBy = fldStdAmd DESC
which correctly sorts my data when I open Subform2. But when I open the Main
form Subform2 is not sorted.

I have tried the following code in Mainform

Private Sub Form_Load()
Forms!fsubStdIssues.Form!fsubStdAmds.Form.OrderBy = "fldStdAmd DESC"
End Sub


Thanks for any help,

Seth
 
I have:

Mainform
Subform 1
Subform 2 (continuos form I want sorted)

I have set Subform2 OrderBy = fldStdAmd DESC
which correctly sorts my data when I open Subform2. But when I open the Main
form Subform2 is not sorted.
Click to expand...

I'd suggest basing Subform 2 on a Query with an order-by clause
sorting the data as you would like.

John W. Vinson[MVP]
 
Either John's method or if you want to stick with the OrderBy, you need to
set the OrderByOn to True.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top