clicking the command button and then without parameter value if i click cancel then a dialog box appear saying stop all macro.

[aligahk06]

Dear All,

I have an access form and when i click the command button and then without parameter value if i click cancel then a dialog box appear saying stop all macro.

Is there any way to avoid this message to display.

Rgds,
aligahk06

 

[Micron]

I suppose one way would be to convert your macros to code procedures. Your macro must be raising an error but you didn't say, yet it's the likely cause for the stop macro prompt. If you don't want to use code, then you will have to structure the macro to prevent whatever error it is raising. Perhaps that is because a value was not provided? Then check for the value first and exit if not found.

 

[welshgasman]

I should expect you can test for the Cancel being pressed or the particular error.?
General consensus from a Google search appears to be use VBA.
You could also see if this link helps.?

Require Data Entry with a Macro | Database Solutions for Microsoft Access | databasedev.co.uk

Require Data Entry with a Macro: If you are using a Microsoft Access database application for data entry you will want to ensure the quality of the data that is being entered. Validating data in Microsoft Access allows you to check data whilst it is being entered into the database, and there...

www.databasedev.co.uk