IIF statement matching with another field 1

[ImperialBlether]

Hi - I'm new here and would be really grateful for some help. I've looked through past threads but haven't found anything similar.

I've got a form on Access with a subform.

On the subform, I want to use IIF to say 'If the item chosen on the drop down (in the subform) is X, then I want the field called 'Area' to show here. If not, I want 'Perimeter' to show.

Area and Perimeter are on the main form.

Please can anyone help?

 

[vlingen]

Lets say your Main form is called "Mainform" and it has two fields: Area and Perimeter.

Then your subform contains two fields
Combo123, AorP

You might want to try something like this in the OnChange of the Combo123

IIF(me!Combo123 = "Area", Me!AorP = Forms!Mainform!Area, Me!AorP=Forms!Mainform!Perimeter)

 

[ImperialBlether]

Thank you, vlingen - that's fantastic.