Hi,
I have a form, frmMainScreenView, and a query, qrySearchBySeniorAdmin. On a separate form I use a combo box to select a Senior Administrator, then on pressing the command button, the following expression is actioned:
DoCmd.OpenForm "frmMainScreenView",,"qrySearchBySeniorAdmin"
This works fine. However, the frmMainScreenView has a number of subforms which are viewed via a navigation which I want to include in the query.
For example, one of the subforms is "frmMembershipCompleted", and within this are two fields I want to filter on: "DateMembershipCompleted" and "DateInvoiceCompleted". If these two fields are left blank, it means they are yet to be actioned, and I want the above query to include this criteria when it opens the form, and only open the records with outstanding actions (or blanks).
I feel like this it is possible to add some extra code to the DoCmd....thread above, such as an Is Null expression, button I cannot fathom this.
I also have a few extra subforms which will need to be brought in to the query/SQL, but as long as I can get one to work I'm sure I can keep replicating.
Thanks,
Phil