Prev: Listbox w/many columns, need update all columns to table
Next: Issue with displaying image on form
From: Frank on 9 Feb 2010 13:43
On Dec 26 2009, 9:38 pm, Ranjith Kurian
<RanjithKur...(a)discussions.microsoft.com> 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
> > <RanjithKur...(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: Listbox w/many columns, need update all columns to table
Next: Issue with displaying image on form