unhide field based on previous fields answer

[CraigR]

Hi, and thanks for any help in advance. That's optimistic :-)

I have a dropdown field "Retaining" with 3 options (N/A = 0; Retaining Wall = 1; Battered = 2.)

if N/A is selected then the form stays as it is, no extra fields visible.

however

If "Retaining Wall" is selected then I want field "Retaining2" including Label to be visible.

or

If "Battered" is selected then I want field "Battered2" including Label to be visible.

with thanks
Craig

[June7]

In the combobox AfterUpdate event:

Me.Retaining2.Visible = Me.Retaining = 1
Me.Battered2.Visible = Me.Retaining = 2

[CraigR]

Thank you very much for your help

Craig