Mr. Steele: Further problem about ODERBY

[Martin \(Martin Lee\)]

First, Mr.Doug Steele, thank you very much for your amazing VBA.

Second, I want to make your method into more generally using. The VBA you
provide is fit for textbox, however in my FORM,I have combobox also. I want
to make your VBA available also to FORM's combo box, how ?

( I have tried to change the vba "textbox" into "combobox", but can't work.)

Thanks!

Martin Lee


----------------------------------------------------------------------------
It sounds, then, like you want something like the following in your button's
Click event:

If TypeOf Screen.PreviousControl Is TextBox Then
Me.OrderBy = Screen.PreviousControl.ControlSource
Me.OrderByOn = True
End If

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)