acFormAdd works - new record doesn't

[Penguin]

Angi, the first error was because your data type was a number not
text. Simple fix.

I don't know why you get a second error. Try this: DoCmd.Close

See if that helps.