Add new record in VBA

[coolpal9]

Hi,



I have a database wherein I have a detailed form to be filled up so that the data provided is automatically updated in the tables in the backend.

But I wanted to ask, when I wish to add more records, how shall I make it go through the code?

What shall i code so that a new record is added and also where shall I place the code, I mean in the form of a module or just a code for a click event.

Also, I read somewhere that using:
DoCmd.GoToRecord,,acNewrRec in the click() event would work it, but I got an error on doing so...

Pl help...

[pdebaets]

what is the error message?

[coolpal9]

The error is:

'You can't use GoToRecord action or method on an object in Design View'

[pdebaets]

Is the button on the "detailed" form, or on another form? Make sure the "detailed" form is open in form view, then try it again.