ImperialBlether
Instructor
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?
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?