Solved Too few parameters - need workaround for invoking form control in recordset

[theDBguy]

Thank you all. I fixed it by putting the form controls inside Eval(). I also didn't understand that variables need to be outside of the sql string and concatenated and fixed that as well. I would like to explore the function from @theDBguy at some point but for now the issue is solved. I also probably could have done it @bastanu's way. Thanks everyone!

Glad to hear you got it sorted out. Good luck with your project.

 

[The_Doc_Man]

Punctuating the dates properly will work. If you have something that works now and are pressed for time, I would advise to keep on this path for now, but eventually you might find something profitable in getting rid of the form and instead using the power of SQL to associate data from two different records that have some factor in common. This might take exploration and I don't want to delay you with your project. But if you are ready to look at this, do some reading and come back with questions.

The issue I suggested with a JOIN can best be understood by looking for topics using the SEARCH function of this forum. You can look for JOIN, INNER JOIN, OUTER JOIN, LEFT JOIN, or RIGHT JOIN (one of those at a time) for reading.