I am receiving the Run-Time Error 2491 while trying to execute an "On Click" event.
I have a form Called [QreValue] and with in that form I have a sub form called [fQreValueSubform]. I have an "On Click" event where I select the "record selector on the subform. This executes a Query/Filter that joins the QREVALE Table to the subform.
It works very well. However, this is not the final product.
The QREVALUE form is then moved into another form Called fMain. fMain is a tabbed form that has several different forms embeded.
The QREVALUE form is placed on a tab/sheet called fQreValueMainSubform.
After doing this my "On Click" does not function. When I perform the "On Click" in the record selector I get the Run-Time Error 2491.
I have attached the db below. Please open two form and see what happens.
Open: fQreValue » Select "All NAMC" » "Select a record" and the filter works fine.
Open: fMain » QRE VALUE tab » Select "All NAMC" » "Select a record" and the error occurs.
I think I need to have all the forms bound together correctly. But am not sure how to do it.
The filter query has the following SQL Code. This