Add new record through Form view

I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.

On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
wrote:

I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.

The Click event should show [Event Procedure], and the code could be

Private Sub buttonname_Click()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord
End Sub


Or you could use a Macro using the Go To Record action.
--

John W. Vinson [MVP]

Thanks for the below code.

I even need a command button to delete the record in a table.

"John W. Vinson" wrote:

On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
wrote:

I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.

The Click event should show [Event Procedure], and the code could be

Private Sub buttonname_Click()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord
End Sub


Or you could use a Macro using the Go To Record action.
--

John W. Vinson [MVP]
.

On Sat, 26 Dec 2009 21:38:01 -0800, Ranjith Kurian
wrote:

Thanks for the below code.

I even need a command button to delete the record in a table.

The toolbox Command Button Wizard will offer this as a choice.
--

John W. Vinson [MVP]

On Dec 26 2009, 9:38*pm, Ranjith Kurian
wrote:
Thanks for the below code.

I even need a command button to delete the record in a table.



"John W. Vinson" wrote:
On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
wrote:

I have a table which is linked to a form, i would like to have a command
button which willaddanewrecord to my table.
On the click of command button it should view the last empty row of my table
in a form.

The Click event should show [Event Procedure], and the code could be

Private Sub buttonname_Click()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord
End Sub

Or you could use a Macro using the Go To Record action.
--

* * * * * * *John W. Vinson [MVP]
.- Hide quoted text -

- Show quoted text -

John,

When I used the code above, I got Run_time error ' 2105' : You can't
go to specified record. Any idea?

Thanks

Frank