Hi experts -
I'm trying to invoke a form with this line:
DoCmd.OpenForm "Vendor_Invoice_Browse", , , "[Vendor_ID]=" & Me.txtVendor_ID & " and [invoiceno]=" & Me.txtInvoiceNo & " and [invoicedate]=#" & Me.txtInvoiceDate & "#", , 3
but it is having problems with the [invoiceno]=me.txtinvoiceno. (I tested - the line works fine when I remove this)
Invoiceno is a TEXT field in the source table, and me.txtinvoiceno is pulling from a query that pulls directly from the table.