View Full Version : Add new record


MikeUK
12-18-2000, 05:35 AM
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
12-18-2000, 05:45 AM
On Click event of your button use this code:

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

Bye, S.

Cedwards
12-19-2000, 12:13 PM
just open a command button and go to record navigations and tell it to add record. Duh!!!