VB Code not working correct in 2007

[SWH]

We are currently switching our offices from Office 2003 to 2007. We have
several MS Access DB's that were created several years ago by people who are
no longer here. The problem I have run into is that when we open or convert
an Access 2003 DB and try to use the forms some of the functions do not work
correctly in Access 2007. An simple examples one form has navigation buttons
that works fine in 2003 but skip randomly through the table in 2007.

It's a simple "DoCmd.GoToRecord , , acNext" that should (and does in 2003)
take you to the next record but in 2007 it starts at record 320 and then, as
the button is clicked, skips randomly through the table records.

I am not the programmer or a programmer but am just trying to get these to
work in Access 2007.

Thanks for any help,

 

[Allen Browne]

If you just click the built-in navigation buttons, are the records in the
same (random) order?

If so, using Access 2007, open the form in design view, and set these
properties of the Form to No:
Order By On Load
Filter On Load

If set to Yes, the records are automatically sorted by whatever field is
named in the form's OrderBy property. Since this property died not exist in
previous versions, A2007 behaves differently unless you set these properties
to No.

You may also need to set this property to No for the table itself.

If the form is based on a query, set the properties for the query also, and
use the Sorting row to define the sort order you want.