G
Guest
Hi i have a macro with the setvalue action (which copies a number of fields
from one form to another) This works fine. However, i wanted a condition that
displays an MsgBox if a value in a field is selected :
[Forms]![Sw]![Type of employment]="LSBU employed (Internal)", then the Msg
box appears
I have another condition
[Forms]![Sw]![Type of employment]="Company" Or "Self employed (External)"
which action is to display another message box saying that it will not copy
the values over if company or self employed.
I added a StopMacro action underneath this row so that it doesnt activate
the setvalue/copying function, but this macro still seems to be copying the
values nonetheless.How do i stop the set value action from happening if the
2nd condition
[Forms]![Sw]![Type of employment]="Company" Or "Self employed (External)"
is met?
Thanks
from one form to another) This works fine. However, i wanted a condition that
displays an MsgBox if a value in a field is selected :
[Forms]![Sw]![Type of employment]="LSBU employed (Internal)", then the Msg
box appears
I have another condition
[Forms]![Sw]![Type of employment]="Company" Or "Self employed (External)"
which action is to display another message box saying that it will not copy
the values over if company or self employed.
I added a StopMacro action underneath this row so that it doesnt activate
the setvalue/copying function, but this macro still seems to be copying the
values nonetheless.How do i stop the set value action from happening if the
2nd condition
[Forms]![Sw]![Type of employment]="Company" Or "Self employed (External)"
is met?
Thanks