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)
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.