Hello,
I am creating a form that contains a series of invoices. I have created a command button that inserts the next number in a series as the invoice number - this is the code I used as "On Click"
If Me.NewRecord = True Then
Me.Invoice = Nz(DMax("Invoice", "Invoices"), 0) + 1
End If
This works great! However, the invoices actually need to be named a combo of letters and number, i.e. XXX1, XXX2, XXX3 and so on. The letters never change. Can I concatenate it somehow so that the entry on the form shows the actual invoice name and not just the number?
I am creating a form that contains a series of invoices. I have created a command button that inserts the next number in a series as the invoice number - this is the code I used as "On Click"
If Me.NewRecord = True Then
Me.Invoice = Nz(DMax("Invoice", "Invoices"), 0) + 1
End If
This works great! However, the invoices actually need to be named a combo of letters and number, i.e. XXX1, XXX2, XXX3 and so on. The letters never change. Can I concatenate it somehow so that the entry on the form shows the actual invoice name and not just the number?