Problem Moving to New Records

[Frank Wagner]

I am totally befuddled. I have an Access2000 database I’ve been using for a
number of years, and I’m suddenly getting the error message “You can’t go to
the specified record†on a number of my forms. It doesn’t happen when I’m in
the debug mode, so I can’t follow it through step by step. I am quite sure
it results from the statement “DoCmd.GoToRecord , , acNext†when the form
finishes processing one record interactively and moves to the next record.

I’ve tried copying the forms into a new database so I can cut down the code
to just the problem step, but it doesn’t happen to the form in the new
database. This made me think my database was corrupted somehow, so I tried
repairing the database, and copying all the objects into a new database and
neither corrects the problem.

I open the form using the following statements, where XYGraphs_Test_3_26 is
a query that selects certain records from a table:

stDocName = "Graphs_XY"
DoCmd.OpenForm stDocName, , "XYGraphs_Test_3_26", stLinkCriteria

I know it’s difficult to help me debug such a problem in this type of forum,
but I’m totally stuck and any help would be appreciated.

Thanks

 

[Tom van Stiphout]

On Thu, 19 Feb 2009 23:49:00 -0800, Frank Wagner

If you think corruption could be an issue, you should restore a backup
of your FE and BE to find out. If the problem goes away, there is your
answer. You already ran Repair & Compact on both?

-Tom.
Microsoft Access MVP