I am struggling to get the value off of an open form into my current form using VBA. I am trying:
Me.InvoiceNumber = Forms!Invoices!InvoiceNumber
But it is not working. Both fields have the same type, Number - Long Integer.
Any ideas what I am doing wrong?
Me.InvoiceNumber = Forms!Invoices!InvoiceNumber
But it is not working. Both fields have the same type, Number - Long Integer.
Any ideas what I am doing wrong?