Help with Sorting (Order By)

[Steven547]

Still new to the VBA programming, but I have a question (probably really simple too...)

Why won't this code sort the list by priority level?

-----------------------------------------------------------

Private Sub Form_Current()

'Update Search Request ID Combo with current selection criteria
strRowSource = "SELECT TBLRequests.RequestID,Request "
strRowSource = strRowSource & "FROM TBLRequests "
strRowSource = strRowSource & "Where Completed = No"
strRowSource = strRowSource & "Order by PriorityLevel"

Me.cboSearchReqID.RowSource = strRowSource
Me.cboSearchReqID.Requery
-----------------------------------------------------------


Is it because of the: Me.cboSearchReqID.RowSource = strRowSource

End Sub

 

[ItIsHardToProgram]

Your strRowSource will only take the value of the last line mentioned in coding, so you either need to put it in 1 string or strRowSource = strRowSource + "SELECT TBLRequests.RequestID,Request " etc.... with every line....


hope this helps

 

[PHV]

Anyway, lack of space before the ORDER BY clause

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Steven547]

I apologize, i'm not fully understanding what you're saying. I placed a space before the ORDER BY and no luck.

ItIsHardToProgram: When you say put it in 1 string or strRowSource = strRowSource + "SELECT TBLRequests.RequestID,Request " etc.... with every line...., That is where i'm getting confused.

 

[PHV]

And this ?
strRowSource = "SELECT RequestID,Request,PriorityLevel "
strRowSource = strRowSource & "FROM TBLRequests "
strRowSource = strRowSource & "WHERE Completed = No "
strRowSource = strRowSource & "ORDER BY PriorityLevel"

Amend the various column's properties of the combo to match this new source.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ItIsHardToProgram]

It is probably the missing space before ur ORDER by that gave you error...