Error When Opening Form in MDE

[mkallover]

I'm having two users test a new version of one of my databases and they are getting an error when they click a button to open a new form. The error is:

The expression On Click you entered as the event property setting produced the following error: The OpenForm action was canceled.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

The button has a simple piece of code on it:

Private Sub Command72_Click()

DoCmd.OpenForm "frmReqSearch", acNormal

End Sub

The users and I are all using Access 2007 but the database is being saved in 2003 format. Of course, it works just fine for me so I can't troubleshoot as well as I would like and Google isn't helping much.

Any thoughts?

 

[newguy86]

Can you type out the name of the form exactly as it appears in the database window?



Travis

http://www.enterprise.com

"Why would I ever want to learn about programming when Micorsoft products would be able to handle even the simplest of tasks. Oh...wait a minute...something's wrong with that statement!

 

[mkallover]

Not sure what you mean but it is "frmReqSearch" most every place I look.

 

[newguy86]

Ok. Try this on for size.

Private Sub Command72_Click()

Dim stLinkCriteria As String

DoCmd.OpenForm "frmReqSearch", acNormal, , stLinkCriteria

End Sub

Travis

http://www.enterprise.com

"Why would I ever want to learn about programming when Micorsoft products would be able to handle even the simplest of tasks. Oh...wait a minute...something's wrong with that statement!

 

[mkallover]

Ah, I figured it out. They were missing an ODBC connection that was necessary to connect to one of the SQL servers being queried.

Once I added that connection, everything was fine.