Sort order

[frys]

Here is what i have

I have 2 cbo boxes cboHomeArea and cboResName
I want it to sort after update the
by [resid].[last]

currentlly it is defaulted to [Resid].[resid]
any help would be great


Private Sub cboHomeArea_AfterUpdate()
Dim sManagerSource As String
sManagerSource = "SELECT [ResID].[ResID]," & _
"[resid].[homeareaid]," & _
"[resid].[last]&', '&[resid].[first]" & _
"FROM resid " & _
"WHERE [homeAreaId] = " & Me.cboHomeArea.Value
Me.cboResName.RowSource = sManagerSource
Me.cboResName.Requery

End Sub

[frys]

Any help would be great

[frys]

I could use a little help with this

[Rabbit]

Use the ORDER BY clause.

SELECT Field1
FROM Table1
ORDER BY Field2;
 

[frys]

i know the syntax... but it after running it with an orderby it shows me nothing
that or it says improper use of data... im not good with VBA to begin with but i think its pretty self explainitory

dim sMangerSource as string

smanagersource="Select [resid].[resid]," & _
"[resid.last]&', '&[resid].[first]," & _
"[resid].[homearea]" &-
"from [resid]"
"where [resid].[homearea]=" me.Homeareacbo.value & _
"order by [resid].[last]"
Me.cboResName.RowSource = sManagerSource
Me.cboResName.Requery

but this is not right..... why...

[Rabbit]

Your spacing is off.

"SELECT *" & "FROM" & "Table1;"
 

will give you
[code=sql]
SELECT *FROMTable1;"

[frys]

Your spacing is off.

"SELECT *" & "FROM" & "Table1;"
 

will give you
[code=sql]
SELECT *FROMTable1;"

I really appreciate the help Rabbit
but. .. i think i need some more training before i battle VBA... this simple code isn't working no matter which way i write it...

thanks anyway

[Rabbit]

All you need to do is get your spacing correct:

dim sMangerSource as string
 
smanagersource="Select [resid].[resid]," & _
"[resid.last] & ', ' & [resid].[first]," & _
"[resid].[homearea] " & _
"from [resid] " & _
"where [resid].[homearea]=" me.Homeareacbo.value & _
" order by [resid].[last];"
Me.cboResName.RowSource = sManagerSource
Me.cboResName.Requery
 

[frys]

Thanks ever so much.. i finnally got it to work.... you where very right the spacing was off..

These little things can cause so much trouble