Attached is a form that is used in our application by one form as a popup form to filter for employees, however I am trying now to expand this filter utility to various forms in our application,
The way I am planning to use it is as follows, insert is as a hidden subform, then when users clicks on filter button, this will move to the center, expand itself to full size and become visible.
One of the reasons of designing it this way is to allow user to have this filter option open multiple times by multiple forms, all at the same time.
Now my question here is, where do I build the dynamic sql? and how do I call it?
I could have written something like this on the main form
if not isnull(Me.SubForm.Form!TextCriteria) then...
however this would require a code modification for each main form every time I update the sub form (meaning the attached filter form).