I am trying to create a switchboard button in Access 2007 that will open a password input box as a security for a form. The switchboard button calls a macro which will then invoke a macro to run the following code:

Public Function Password()

Dim stDocName As String
Dim stLinkCriteria As String
Dim strUserID As String
Dim strPassword As String
Dim strPrompt1
Dim strPrompt2
Dim strTitle1
Dim strTitle2

strPrompt1 = "Enter Password"
strTitle1 = "Password"
strPassword = InputBox(strPrompt1, strTitle1)

If strPassword = "update" Then

stDocName = "Issue Log"
DoCmd.OpenForm stDocName, , , stLinkCriteria
MsgBox "Your are not Authorised to access this"
End If


End Function

The code works when I run the macro, I get this error message:
"The expression you entered has a function name that Microsoft Office Access can't find."
and returns and Action Faile with Error Number 2950.

If I click the switchboard button, I get this error message:
"The object doesn't contain the Automation object 'Password.'"

Can someone please point me in the right direction?

6 Years
Discussion Span
Last Post by kjet1

I figured it out. My module and function names were the same. Thanks

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.