I get an "Enter Parameter" box when clicking the 2nd combo box on subform which is on the mainform. Is the reference in the query incorrect ? If so what should it be ? I attach the db so you can see exactly what I mean.. Thanks for any guidance.
I get an "Enter Parameter" box when clicking the 2nd combo box on subform which is on the mainform. Is the reference in the query incorrect ? If so what should it be ? I attach the db so you can see exactly what I mean.. Thanks for any guidance.
I haven't looked at your db yet but here's a good reference for the syntax: http://www.mvps.org/access/forms/frm0031.htm
Im not getting the error on the mainform sub.