"Mike Revis" <m***@hazmatexpress.com> wrote in message
news:111no4m65et0c2c@corp.supernews.com...
> Hi Group.
> Access 2000. Win xppro.
>
> I have created a command button to delete the current record on my form.
>
> The command button created by the wizard uses the DoMenuItem.
>
> It gives me an error of "No Current Record" after deleting the record.
>
> I made another one without the wizard using DoCmd.RunCommand
> acCmdDeleteRecord
> This gives me an error of "Runtime Error 3021 No Current Record". With the
> option to End or DeBug. When I select DeBug the DoCmd.RunCommand
> acCmdDeleteRecord line is highlighted.
>
> I have read everything I can find in Access VBA help on No Current Record
> but quite frankly Microsoft help usually gives me a headache and little
> else.
>
> As usual any advice or suggestion is welcome.
>
> Thank you
>
> Mike
>
>

>
> Regards,
>
> Naresh Nichani
> Microsoft Access MVP
>
> "Mike Revis" <m***@hazmatexpress.com> wrote in message
> news:111no4m65et0c2c@corp.supernews.com...
> > Hi Group.
> > Access 2000. Win xppro.
> >
> > I have created a command button to delete the current record on my form.
> >
> > The command button created by the wizard uses the DoMenuItem.
> >
> > It gives me an error of "No Current Record" after deleting the record.
> >
> > I made another one without the wizard using DoCmd.RunCommand
> > acCmdDeleteRecord
> > This gives me an error of "Runtime Error 3021 No Current Record". With
the
> > option to End or DeBug. When I select DeBug the DoCmd.RunCommand
> > acCmdDeleteRecord line is highlighted.
> >
> > I have read everything I can find in Access VBA help on No Current
Record
> > but quite frankly Microsoft help usually gives me a headache and little
> > else.
> >
> > As usual any advice or suggestion is welcome.
> >
> > Thank you
> >
> > Mike
> >
> >
>
>