The openform action was cancelled < Removing this message

[rsteenoven]

When I click a button that links to a macro that links to a query form thing, if I press cancel on the enter paramater box, this message is displayed.

the openform action was cancelled

How do i make it so that when I click the cancel button, this message does not appear?

 

[HiTechCoach]

When I click a button that links to a macro that links to a query form thing, if I press cancel on the enter paramater box, this message is displayed.

the openform action was cancelled

How do i make it so that when I click the cancel button, this message does not appear?

You will need to add Error trapping for Error Code 2501.

 

[HiTechCoach]

I just remembered that one of the BIG problems with using macros is that it is very difficult to add error handling.

I would urge you to convert th macro to VBA code then you can use something like:

Private Sub MyCommandButton_Click()

    On Error GoTo Err_MyCommandButton_Click

'
' you code here
'


Exit_MyCommandButton_Click:
    Exit Sub

Err_MyCommandButton_Click:
    If Err.Number = 2501 Then
        Resume Next  
    Else 
        MsgBox Err.Description
        Resume Exit_MyCommandButton_Click
    End if 
End Sub

 

[rsteenoven]

I don't really understand how I would do that tbh.

 

[HiTechCoach]

I don't really understand how I would do that tbh.

What part do you not understand?

How to convert your Macro to VBA code?

How to create the error handling?


This may help:
Error Handling and Debugging Tips and Techniques