Print Report IIF function

[Seph]

Good day everyone,

I have a subform "InvoiceActiveList" on my main form "Invoice" form.

I have an On Click event that opens a report in Print preview based on the clicked InvoiceNumber

Is it possible to create a function that if the SalesInvoice Yes/No field is true then it opens a different report (E.g. InvoiceSalesR) and if false then InvoiceJobR?

Thank you!

 

[June7]

Certainly.

DoCmd.OpenReport IIf(SalesInvoice, "InvoiceSalesR", "InvoiceJobR"), acViewPreview, , "InvoiceID=" & InvoiceID

 

[Seph]

Certainly.

DoCmd.OpenReport IIf(SalesInvoice, "InvoiceSalesR", "InvoiceJobR"), acViewPreview, , "InvoiceID=" & InvoiceID

You Sir/Mam are my Hero!

Thank you!