Order by On Continuous Form

[KSReynolds]

How do I set in vba the orderby, when the order by is selected from a drop-down box? Access 2000.

 

[pr2-eugin]

Try the AfterUpdate of the ComboBox, something along the lines of..

Private Sub comboBoxName_AfterUpdate()
    Me.OrderBy = Me.comboBoxName
    Me.OrderByOn = True
End Sub

 

[KSReynolds]

Oh Yes!!!! I got it to work. After the user selects his sort criteria from the selection form that has a combo box bound to the value of the field name, I put this code in the On Open event of the continuous browse form:

Me.OrderByOn = True
Me.OrderBy = "[" & Forms![frmSupplierFeedbackSelectSort]![SupplierFeedbackField] & "]"