open form code question

[budchevy]

Dealing with someone else's VBA code here , but here is what I have:

Private Sub RvIIA_Click()
On Error GoTo Err_RvIIA_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "FrmIIA"

stLinkCriteria = "[Auditor]=" & "'" & Me![Auditor] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_RvIIA_Click:
Exit Sub
Err_RvIIA_Click:
MsgBox Err.Description


Resume Exit_RvIIA_Click

End Sub

I need this sub to open the form "FrmIIA" and sort the records by date for the "auditor" in question..

[June7]

Set the sort order in the form's RecordSource query or if the RecordSource is just a table, use the form OrderBy and OrderByOnLoad properties.

[budchevy]

this VBA code is from a command button inside the form.. Not sure how to set the sort order other than with code, which i suck at

[June7]

The sort order can be specified within an Access query or in the properties of the form. Neither involve code.

[budchevy]

The form has 8 command buttons inside it. The code for these buttons refer to other forms, all of which do different things. I don't see how I can set the sort order inside the form?

[June7]

Those properties would be set in the form or report that is being opened. If you want a different sort order at run time, then modify the property with code. Macros might be able to do these actions, but I use only VBA.

If you want to build db with advanced features, need to get comfortable with coding. Start with http://office.microsoft.com/en-us/ac...010341717.aspx

[budchevy]

I learned VB 15 years ago, I'm comfortable messing around with other peoples code. I was just looking for someone to help me out with a quick fix.. thought that was the purpose of the forums?

[June7]

I have given you possible 'quick fix' options but really not much info to work with. What do the 8 buttons have to do with the sort order of the form "FrmIIA"?

Suggestions are:

1. set sort order in query that form is bound to
2. set sort criteria in the form SortBy property
3. use code to set SortBy property

You said your coding skills were weak so I referenced a resource to improve.

Unless you want to provide the project for analysis, that's all I can offer.