Ok since I can't open a report directly in a subform I am trying a work around.
Using the query to show my data (that would have been in the report) I created a form in datasheet view.
I want the form to open in the UI builder main form and display only the data based on a specific due date.
To accomplish this I have:
Created frmInvoice with and unbound text box
Created the query with this in the criteria box: [Forms]![frmmain_expandlg]![Subform1]![Due Date]
Inserted the query's form as a subform in frmInvoice named: qryfrmfeedue
When I open the frmInvoice from design view to form view outside of the main UI Builder form, a box pops up asking for my criteria, I enter the date and the data appears on the form.
But I when I open frmInvoice and enter data in the unbound text box it doesn't work.
I would prefer the qryfrmfeedue opens on the frmInvoice after I enter the due date in the unbound text box.
But I can't figure out how to get it to recognize the date run the underlying query.
Next I tried creating a button that would open the form, which it did, but in a new window.
Next I tried adding the qryfrmfeedue on the Invoice submenu with submenu button 'Preview Invoices'. It will open the form, but does not ask for the criteria to be opened.
I have attached a screen shot of the frmInvoice how I want it to look in case that helps.