Little Penny,
Ah, ok. Well, what you are really talking about here is going to a
blank record on the form, with the option for you to create a new record
by entering data. A new record in the UserInfo table is not added.
Use this code on the Click event of the command button...
DoCmd.GoToRecord , , acNewRec