I have connected a form to the DB using an ADODC. I connect fine, I can read the DB if I put a literal in my sql:
recordsource = select * from table1 where employeenum = 108
But, I want to use the value that is stored in the employee text box.
recordsource = select * from table1 where employeenum = form2.candidatenum.text
I get the message, “No value given for one of more required parameters”.
You have to concatenate the text box value to your SQL statement, like so:
recordsource = "select * from table1 where employeenum = " & form2.candidatenum.text