"if then else" inside "add record"
when updating data at form 1, a new record is created at form 2
some fields are directly transfered from form 1 to form 2
this is acomplished with "add record".
but form 2 has a field (a) wich value depends on a value of a field (b) at form 1. That value has only two possibilities and should be obtained by a "if then else" with a value of a field (b) of form 1.
how can this "if then else" work inside "add record"?