Hello everyone,
I want to retrieve and display the last PO number from my table on my access form, and able to edit the PO Number and i want to increase my number by 1.
Below is my code for my PO Number increment:
Dim PONumber As String
PONumber = Me.txtPONumber
Me.txtPONumber = Me.txtPONumber + 1
Besides that i have also use DMAX under control source to display the last PO number, but after i used the DMAX i am unable to increase my number by clicking on my "SavePO" button.
How can i display the last PO number, edit the PO number and able to increment it?
I want to retrieve and display the last PO number from my table on my access form, and able to edit the PO Number and i want to increase my number by 1.
Below is my code for my PO Number increment:
Dim PONumber As String
PONumber = Me.txtPONumber
Me.txtPONumber = Me.txtPONumber + 1
Besides that i have also use DMAX under control source to display the last PO number, but after i used the DMAX i am unable to increase my number by clicking on my "SavePO" button.
How can i display the last PO number, edit the PO number and able to increment it?