Need Help with message box.

[Grahamvdh]

Hi



I have built a input form that is going to populate a table, it is all very simple.
The data capture person gets a piece of paper with info on and needs to capture it.

I have added a button that does the save and new task, and brings up a message box that says remember to write the PTO Number down.
I would like this message to say "Remember to write W000013 down before filing the PTO"

How do I get this auto number populated in the popup?
The primary key is called PTO_Number it id an auto number with a prefix W.

Thank you for any help

[Robeen]

If the value of PTO_Number is on the Form at the time when the button is clicked, you can do something like this:

Dim strPTO_Number as String

'Assuming that your PTO_Number text Box on the Form is named 'PTO_Number' . . .
strPTO_Number = "W" & CStr(Me.PTO_Number)
MsgBox "Remember to write " & strPTO_Number & " down before filing the PTO!"

I hope this helps!