Hey there, im doing a form for physical assessments and have my first column as body location(A) and the second column(B) are the tests. once a location is selected from a drop down a list of test for that body region show up in the drop down field in the second column.


EX
A1 B1
A2 B2
I want to make it possible so that if formfield A2 is left at the default value formfield B2 loads the list associated with the value of A1. This is kind of what i want but the coding is not right

If formfield(A2).result = "default value" Then
formfield(A2) = formfield(A1).result