problem calling macro

[ch4meleon]

i have written a very basic macro and called it finduser i have attached it to a button but when i click the button i get an error message telling me it cant be found becasue it doesnt exist or is new and hasnt been saved yet. i have been in and out of the database & saved it but i still get the same error - ive not had this prob before and i dont think ive done anything differently to what i have done previously ??
any ideas please on what ive done wrong ?
thanks

 

[hneal98]

It sounds like the button is expecting a VBA function and you are supplying a macro. You have two options in that case, ether convert the macro to vba or inform the button that it is a macro, not vba.

If you want to run the macro, your code in the On-click event of the button migh look something like this:

Private Sub Command422_Click()
On Error GoTo Err_Command422_Click

    Dim stDocName As String

    stDocName = "Macro1"
    DoCmd.RunMacro stDocName

Exit_Command422_Click:
    Exit Sub

Err_Command422_Click:
    MsgBox Err.Description
    Resume Exit_Command422_Click
    
End Sub