|Posted: 21 October 2004 at 6:51am | IP Logged
I am trying to run a report from a form which consists of three embeded Forms (The report is actually an Invoice)
frmOrder Detail is embeded into frmOrder and (frmOrder-OrderDetail) embeded into frmCustomer
I cannot get a filter to work which will print an invoice for ONLY The Current Customer The Order and Order Detail showing on the form
However Using only 2 forms that is to say, the frmOrder and frmOrderDetail (embeded) Then I can run the report (Invoice) using the following technique
Create a query for the Invoice Called it Q_Invoice
Create a second Query called Q_InvoiceFilter and using the (Q-invoice) as the "Table" then dragging Q-Invoice (First Grid Column)
Then Dragging OrderID (Primary Key) to the Second Grid Column
Then typing in under the OrderID the filter criteria
[Forms]![frmOrder]![OrderID]. now this works fine....However....
Is there a way I can run an Invoice for a specific Customer/Order/Order Detail from the Three embeded Form scenario using either QBE Grids or SQL or keying expressions into the control property of any/all of the forms.
This would be my preferred solution
Advice would be appreciated