VBA question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Back
Top