P.O information.

[Guest]

Hi. I;m from Mexico and my English is not very well..

I have a Data Base for purchase, but the question is: how increment a P.O if
it's not the Autonumber , it's text field. for example this is the PO:
PO-MT0001 and the next need to be: PO-MT0002 ..

can anyone help with this please..

Thank you so much...

this is my E-mail..

(e-mail address removed)

 

[Guest]

Create an event for your PO field of the form so on double click it will
SetValue to "PO-MT" & right("000" &
(val(right(Max([YourPOTable].[PONum]),4)+1),4)

 

[Guest]

Hello my friend, I did this but it does not work yet..

Here is what I put in the event.

Private Sub PONumber_DblClick(Cancel As Integer)
SetValue "PO-MT" & Right ("000" &
(val(Right(Max([Purchase].[PONumber]),4)+1),4)

End Sub

Where PONumber is the field and Purchase is the Table, please could you
check and let me know what I did incorrect...

Thank you so much..
I will appreciate if you send me an example to : (e-mail address removed)
but Also I will appreciate your response here on the Forum

Thank you...

Create an event for your PO field of the form so on double click it will
SetValue to "PO-MT" & right("000" &
(val(right(Max([YourPOTable].[PONum]),4)+1),4)

Hi. I;m from Mexico and my English is not very well..

I have a Data Base for purchase, but the question is: how increment a P.O if
it's not the Autonumber , it's text field. for example this is the PO:
PO-MT0001 and the next need to be: PO-MT0002 ..

can anyone help with this please..

Thank you so much...

this is my E-mail..

(e-mail address removed)