Key outo number to populate a message box

[Grahamvdh]

Hi

I have a simple form that is used to populate a table, upon "save and new" I would like a message box to pop up that says the following.
REMEMBER !
Remember to write the (PTO Number) on the on the form before adding it to the file.



The PTO Number is the index key and is an auto number.

Thank you so much!

[pbaldy]

With an Access table the autonumber is populated as soon as the record is started, so have you tried:

MsgBox "Remember to write " & Me.FieldName & " on the form..."

[Grahamvdh]

Hi Pbadly

Thank you for the info

I did this

Private Sub Form_Dirty(Cancel As Integer)
MsgBox "Remember to write " & Me.PTO_Number & " on the form..."
End Sub

Not quite right. The popup comes up as soon as the field populates itself but it the number is not there?

Am I on the right track here or what?

[pbaldy]

Is the data in an Access table or something else? Typically I'd use the before or after update event of the form for this type of thing (at the end of their process), but that's me.

[Grahamvdh]

Let me get back to where I started
I created an embedded macro to run on the click of the save and newbutton.
The button works perfectly and the message work but says this ""Remember to write " & Me.PTO_Number & " on the form...""

Instead of Remember to write O00013 down etc.

PTO_Number is the name of the field in the table.

Thanks again for helping a total noob

[pbaldy]

I don't use macros, so I don't know if you can get a value from the form to include in the message.