Add new record

[MikeUK]

I would like a form, with a button, which, when pressed, would go directly to another form, the "Customer Form" with blank spaces ready for the entering of data. I am finding it hard to do this and have no experience of using Visual Basic. Can anyone help?

 

[S]

On Click event of your button use this code:

DoCmd.OpenForm "FormName"
DoCmd.GoToRecord acDataForm, "FormName", acNewRec
DoCmd.Close acForm, "CurrentFormName"

Bye, S.

 

[Cedwards]

just open a command button and go to record navigations and tell it to add record. Duh!!!