Message Box Containing Primary Key

[paul2003abc]

I am creating a database which contains customer information. What I want to do is once the record has been added using a form i want to press a command box which will save the record, open the message box and then close the form. I have worked out the save and close part. The problem is working out how to get the message box to say "New Record Added - Number X" where x is the customer id number"

Any ideas?

 

[WayneRyan]

Paul:

MsgBox("New Record Added - Number " & Me.CustomerID)

Wayne

 

[paul2003abc]

Here is what I have so far:

DoCmd.GoToRecord , , acNewRec
MsgBox ("New Record Added - Number " & tblCustomers.CustomerID)
DoCmd.Close

However it does not appear to be working...and ideas?

 

[paul2003abc]

Using:


DoCmd.GoToRecord , , acNewRec
MsgBox ("New Record Added - Number " & Me.[CustomerID])
DoCmd.Close

It works however...the message box only says 'New Record Added - Number' (ie with the actual number missing)