Select statement

[cschaffer]

Hey there...this is what I want...I want to pass a variable into a SQL select statment

example
dim variable = blah blah

strQuery = "SELECT * FROM Disasters WHERE DisasterType = 'variable'"
.......
not that hard.....how would I reference "variable" from within the SQL statement...very basic I know...just learning.....

CS

 

[JerryDennison]

You would reference the variable as you would any other VB object. If the variable is a control on a form for example you'd use the following syntax:

strQuery = "SELECT * FROM Disasters WHERE DisasterType = Forms![FormName]![ControlName]"

or


strQuery = "SELECT * FROM Disasters WHERE DisasterType = " & Forms![FormName]![ControlName]

 

[rac2]

dim X = "blah blah"

strQuery = "SELECT * FROM Disasters WHERE DisasterType = '" & X & "'"

 

[cschaffer]

Thanks for the help people!

CS