MS Access 2013 field visibility depending on criteria

[state90]

I have a a combobox (Combo118) on a form ([Frm_REVIEW_Parameter]) in which the options are either "U$D" or "LC".

I have a report ("RPT_REVIEW_EE") on which I want either the U$D number to be visible or the LC numbers to be visible depending on the selection in Combo118.

In the After Update area for the combobox (Combo118) I have the following code which is far from working!

Private Sub Combo118_AfterUpdate()
If Me.Combo118 = "LC" Then

Me.Currency.Visible = True
Me.Text115.Visible = False

Else
Me.Currency.Visible = False
Me.Text115.Visible = True

End If
End Sub

Thank you in advance to anyone that can help me make this work.

Kurt

 

[pbaldy]

That type of thing would also require code in the current event of the form:

http://www.baldyweb.com/ConditionalVisibility.htm

 

[state90]

Thank you!

 

[pbaldy]

Happy to help!