Database Quits at DoCmd.OpenForm?

[samn265]

I have a database that I converted from Access97 to Access2000. This database is copied from a server to a local workstation and gets executed from that station using AccessXP. I am puzzled of why the database quits on only one specific workstation but not the others. After I inserted some toggle points, I was able to find out what line of codes it is stopping at. Here is the line:

DoCmd.OpenForm "RM FORM PARTIAL CK", A_FORM, , , A_EDIT, A_HIDDEN

Do you guys see anything wrong with this code. Keep in mind that I do not have any problems with any other machines that run the same database!

Also, if I replace the above code with this:
DoCmd.OpenForm "RM FORM PARTIAL CK" by removing the “A_FORM, , , A_EDIT, A_HIDDEN” section from the code, the database will run with no problem!

I checked the references in all machines and they appear to have the same ones.

Any ideas, hints?

Thanks,
Sam
East or West Home is Best.

 

[jebry]

Hi Sam!

Maybe the constant names have changed. They should be in A2k acNormal, , , acFormEdit, acHidden

hth
Jeff Bridgham
bridgham@purdue.edu