Code:
Me.InvoiceNumber = DLookup("InvoicePrefix", "Property", "PropertyID =" & Me.PropertyID) & Format(Me.txtInvoiceDate, "mmyy", vbMonday)
I'm using this unbound txt field in a form to calculate the invoice number since it is something that can be calculated from the given data. But now when i try to add new invoice i get error propertyid not found becuase of this line of code in vba...
any suggestions