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