VBA question

C

Connie

Hi
I have created a macro that allows users to copy a number of fields/data
using the setvalue action from one form to another(i have a form with a
button called Copy data', and its onclick property executes this macro. This
works fine.

However, i would like to display an error message if the field : Info
type=archived that says "will not copy data that is archived" and obviously
wont execute the macro that allows a user to copy data . Any other values in
the field will allow users to copy data.

Thanks in advance
 
A

Andreas

You can use the condition column in your macro to check for the value.
You will need 2 tests:
- If the value is "archived", display a message box
- If the value is not "archived", do what you currently do.

Regards,
Andreas
 
C

Connie

Thank you :)

Andreas said:
You can use the condition column in your macro to check for the value.
You will need 2 tests:
- If the value is "archived", display a message box
- If the value is not "archived", do what you currently do.

Regards,
Andreas
Click to expand...
 
Top