Re: RunCommand not working

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: smk2 (anonymous_at_discussions.microsoft.com)
Date: 05/08/04 

Date: Sat, 8 May 2004 08:11:04 -0700

okay, sleuthing this out, this is what I've discovered:

if this is the first record to add, the following line works fine:
this was my previous code a few weeks ago, but changed because it worked erratically.

        DoCmd.GoToRecord , , acNewRec

if there are no records, the following line will fail (but not the former):

        RunCommand acCmdRecordsGoToNew

So it would appear that there is some instability within Access itself.
Any comments?
Thanks
SMK