Variables in SQL statements

[casox]

How do I include a variable in an SQL statement? ie What is wrong with this one? strQuery = "Select * From JobStatusEntries Where FormNum = FormNumber" I get "No value given for one or more required parameters" when I try to adodc1.refresh the control. Thanks,

casox

[MartinLiss]

Here's an example

SQL = "DELETE FROM SavedSystems WHERE SystemName = " & "'" & sSysName & "'"

And just in case you can't read it, the symbols around the variable sSysName are a single quote within double-quotes.
------------------
Marty


[This message has been edited by MartinLiss (edited 01-04-2000).]

[casox]

Martin,

It works! Thanks much.

Kim