how to retrieve and display the last PO Number on access form? (1 Viewer)

luzz · Sep 11, 2017

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?

pbaldy · Sep 11, 2017

DMax() would be a common method. Why can't you use it?

luzz · Sep 11, 2017

pbaldy said:
DMax() would be a common method. Why can't you use it?

below is my dmax code:
=DMax("PONumber","RunningNo")

I mean DMAX is great, it display the last POnumber store in my table, but when i use DMAX, my PONumber will not increase after i click on "SavePO" button

pbaldy · Sep 11, 2017

You should be able to add 1 to that textbox just as you did above.

luzz · Sep 11, 2017

pbaldy said:
You should be able to add 1 to that textbox just as you did above.

so in my control source should be:

=DMax("PONumber","RunningNo") + 1?

pbaldy · Sep 11, 2017

That would display the number, but not save it. You'd have to place that value in a bound control with code.

luzz · Sep 11, 2017

pbaldy said:
That would display the number, but not save it. You'd have to place that value in a bound control with code.

Ok, thankyou.

pbaldy · Sep 11, 2017

No problem.

how to retrieve and display the last PO Number on access form? (1 Viewer)

luzz

Registered User.

pbaldy

Wino Moderator

luzz

Registered User.

pbaldy

Wino Moderator

luzz

Registered User.

pbaldy

Wino Moderator

luzz

Registered User.

pbaldy

Wino Moderator

Similar threads

Users who are viewing this thread