I have a subform (a list of invoices for a company). I've written code so when the user dbl clicks on the Invoice Id field, in the subform, it displays the actually invoice.
This works fine when you click on the first (top) record in the subform (datasheet). If you click on any other record in the subform, the invoice prints blank with #type! in the the address field of the report (i.e. no data).
Why would it work on only the first record in the subform.
DoCmd.OpenReport "rptInvoice", acViewPreview, , "[InvoiceID] In (" & InvoiceID & ")"
I can see it passing the invoiceid to the string on the request from both the first record and the subsequent records but the report only contains data when you click on the first record.