Data macros and message boxes

[Mocha Float]

Hello guys,

First of all I'd like to point out that I'm working in Access 2010 Web.

I noticed that data macros can't run the MsgBox function; only normal macros can. Also, data macros can only run other data macros, so here's my problem:

I need to run a message box notifying the user of an invalid input into a table if that be the case. I am using a Before Change data macro to check if the change is valid or not, but I need to be able to point out to the user what exactly the problem is.

Any tips on how to get this working, or a different solution would be greatly appreciated!

Thanks

 

[AccessJunkie]

Hi,

Use the RaiseError data macro action to display whatever error message you'd like.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[Mocha Float]

That completely solves my problem! Thank you very much