Save/Add New on a form

[TammyT]

Okay, sorry to bug y'all with this one, but my "cheat sheets" are on a CD at work, & I'm at home! Simple question:

On a form, once the data is entered, users need to choose between "Done" (okay, I can handle that one!) and "Add Another Item". On the add another - I need the code for saving the record info entered & then clearing the form to add a new record - I just can't remember the text for it.

Thanks!

 

[TheAceMan1]

How are ya TammyT . . .

. . . and this;

[blue]   DoCmd.RunCommand acCmdSaveRecord
   DoCmd.RunCommand acCmdRecordsGoToNew[/blue]

See Ya! . . . . . .

 

[ZOR]

I usually cheat if I forget the code with command buttons, and add a button using the wizard. When its done I open up the code its generated and use it. Lazy me.

 

[TammyT]

Thanks, AceMan!! Yeah, I knew that!

Zor - I've done that as well, but wouldn't apply for this need. I did use it earlier, though, for the simple "pick a name in the drop-down & go to that record" option!

 

[TheAceMan1]

TammyT . . .

[blue]So the status of this thread is? . . .[/blue]

See Ya! . . . . . .

 

[TammyT]

Oh - sorry - yeah, that did it! Thanks.