What is the VB code to add a new record "on click"? I have some code running
that sends an email after they click on the form, and I basically want the
form to be cleared (aka by a new record).

Thanks!

DoCmd.GoToRecord acDataForm, Me.Name, acNewRec

--
Brendan Reynolds
Access MVP


"paula k" <(E-Mail Removed)> wrote in message
news:562F0117-53F2-4EC6-BC4E-(E-Mail Removed)...
> What is the VB code to add a new record "on click"? I have some code
> running
> that sends an email after they click on the form, and I basically want the
> form to be cleared (aka by a new record).
>
> Thanks!