Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

on openform error 2501

Status
Not open for further replies.

Lhuffst

Programmer
Jun 23, 2003
503
US
I have read alot of messages saying they could not open a form using criteria.
I am simply trying to open a form (no criteria).
This system has been fine for years but due to us having to upgrade to 2010 from 2003, I had to rewrite the login/security forms to do away with the workgroup files.

my code is

Code:
System generated version
     Dim stDocName As String
     Dim stLinkCriteria As String
     stDocName = "Main Menu"
     DoCmd.OpenForm stDocName, , , stLinkCriteria

Changed to this when that didn't work
    DoCmd.OpenForm "Main Menu", acNormal
    DoCmd.Close acForm, "MainScreen"

The only oddities are:
1. some people are on 2003 and some 2007.
2. Some people have full rights and some have read only rights

When I tried to test the read only rights all of the sudden it started to give the readonly user and myself (full rights) the 2501 error.
I have checked for missing references and registered comctl32.ocx but still get this error.
Any ideas what I need to check or do next?
Thanks
lhuffst
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top