This is a picture of a section of my report. Depending on the selected option in the top group, the lower option group may or may not be visible. When it's not visible, I would like the LMAS header to shrink so there isn't blank space. I have the header set to Can Shrink. Option groups don't...
I'm working in a report, not a form. The option groups have no events.
I realized the if statement should depend on the table, not the report. Here's the code I'm using now:
Private Sub Report_Open(Cancel As Integer)
If Tables!tblRASerialNumberEval!LMAS - WorkingOrder = 2 Then...
Hello,
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...