Works on one computer, not on another

[Donna]

I created a database on one computer & went to use it on another computer,
but one of the forms won't work properly. Both machines are using Access
2003. I copied the "goofy" one to a CD, installed it on the first machine &
it works fine. I put it back on the second machine & it won't open the form
properly. I've compacted it too.

The user is suppoed to double-click on a name to have the subform link to
the criteria that the Customer ID on one form opens to the customer ID on the
second form. It goes to the debug screen, or gives some error that it's
missing an ID when accessed on the second machine. Has anyone ever had this
problem & do you have any suggestions as to what might be going on? It's
hard to fix something that doesn't appear to be broken.

 

[Douglas J. Steele]

Whenever an application works on one machine but not another, or worked one
day and not the next, the first thing to do is check whether there's a
problem with the References collection.

My December, 2003 Access Answers column for Pinnacle Publication's Smart
Access, entitled "But it worked yesterday!", discusses this issue. You can
download the column and sample database (for free) at
http://www.accessmvp.com/djsteele/SmartAccess.html, or you can check
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html