Access2003 to 2007 problem

[Peter Kinsman]

A client has moved from Server 2003 to Server 2008 SP2 and Office 2003 to
2007. This has caused a number of problems including the following:
A form created in July 2008 to input actual issues has a subform
sfrmQuantitiesItems listing individual Order Items and another
sfrmQuantitiesIssues displaying available stocks in to enter issues. They
are separate subforms and not subform within subform. A command button on
the main form processes the issues for each item and running Access2003 used
to run the following code to move to the next Item row:
Me.sfrmQuantitiesItems.SetFocus
DoCmd.GoToRecord , , acNext
Running Access2007 it gives the not unfamiliar Error 2105 You can't go to
the specified record.

Most of the other problems I can deal with, although in the re-design
Microsoft have changed a lot of keyboard actions for whatever reason, but
this has got me stuck. Any suggestions please?

Many thanks

Peter Kinsman

 

[Peter Kinsman]

Thank you very much Allen. I will try that next week.

Peter

 

[Peter Kinsman]

I have finally got this to work, by enabling oune of the controls on the
subform. I will check by trying the database on a PC with Access 2003, but
I do not remember changing anything when we moved to Access 2007.

Do you get confused now that so many of the keyboard shortcuts have been
changed?

I will keep you informed.

Peter