I have this code set up in the Detail_Format sub.
background on report:
Me!txtZA has the control source [Left Side Depth]
Me!txtZB has the control source [Right Side Depth]
What I want:
If [Right Side Depth] is empty I want it to show the same depth as the left side
Things I have tried:
If IsNull(Me![Right Side Depth]) Then
Me![Right Side DI Depth] = Me!txtZA.value
End If
If IsNull(Me![Right Side Depth]) Then
Me![Right Side DI Depth] = Me![Left Side DI Depth]
End If
If IsNull(Me![Right Side Depth]) Then
Me!txtZB.value = Me!txtZA.value
End If
Any help on this would be appreciated, thanks.