Question:
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”.
Answer:
You have to concatenate the text box value to your SQL statement, like so:
recordsource = "select * from table1 where employeenum = " & form2.candidatenum.text
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
