T
tawreq
Hi all
This is so frustrating - all I want to do is pass the variable of a
combobox into a sql query and run it - does anyone have any ideas? I've
looked around on the groups and found that "& variable &" seems to work
but I'm getting a 'runsql requires an argument that consists of SQL'
error on the following
___
Private Sub Combo0_AfterUpdate()
Dim val As String
val = Combo0.Value
DoCmd.RunSQL ("SELECT Together.Source.[Application Name], ['" & val &
"'] AS Expr1, Together.Target.[Application Name], Together.[Feed
Name/Ref] FROM Together WHERE (((Together.Target.[Application Name])='"
& val & "')) OR (((Together.Source.[Application Name])='" & val &
"'));")
End Sub
__
Thanks a million!
Tariq
This is so frustrating - all I want to do is pass the variable of a
combobox into a sql query and run it - does anyone have any ideas? I've
looked around on the groups and found that "& variable &" seems to work
but I'm getting a 'runsql requires an argument that consists of SQL'
error on the following
___
Private Sub Combo0_AfterUpdate()
Dim val As String
val = Combo0.Value
DoCmd.RunSQL ("SELECT Together.Source.[Application Name], ['" & val &
"'] AS Expr1, Together.Target.[Application Name], Together.[Feed
Name/Ref] FROM Together WHERE (((Together.Target.[Application Name])='"
& val & "')) OR (((Together.Source.[Application Name])='" & val &
"'));")
End Sub
__
Thanks a million!
Tariq