Unanswered: Hiding option buttons based on other option buttons
I'm making a report in Access 2003. I have one sent of option buttons named workingorder and another set named compcondition. When option 1 and 3 are selected in workingorder, I would like compcondition to be hidden. When option 2 is selected, I need to see compcondition.
I have limited experience with code so hopfully it's just an easy fix that I'm missing. My code in the On Open event for the report is:
Private Sub Report_Open(Cancel As Integer)
If Me.fmeLMASWorkingOrder = 2 Then Me.fmeLMASCompCondition.Visible = True Else Me.fmeLMASCompCondition = False
It tells me I have an expression that has no value and highlights "If Me.fmeLMASWorkingOrder = 2 Then"
I've tried a couple different ways can can't get this to work. Please help!