Capture created PO number in code

[dichetdi]

Hello,

Does anybody knows how to get the PO number that just got created/inserted? I ran the recorded vba code and it ran with no errors, but how do I know what's the PO number? I would like to put up a message box to show the created PO number that just got inserted.

Thank you.

 

[ettienne]

The PONUMBER field is populated after you .Insert the header.

 

[dichetdi]

Yes, I was querying the header table but that's not the best way to get the PO Number when I have multiple users creating PO. That's why I was wondering if it's possible to capture the created PO number return when post.

 

[Jay Converse]

Pay attention. The PONUMBER field is populated after you .Insert the header.