Listing info on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report lising case information. I am listing the case#, SS#,
finding, Element#'s (which are: 10, 11, 12, 13, 14) for each case. I have
findings of Correct, Discrepancy, Error and Drop. What I want to do is, that
if the case is Correct, I don't want to list the Element#'s just the Case
Number, SS#, and Finding.
How can I go about this. Thanks
 
Lou said:
I have a report lising case information. I am listing the case#, SS#,
finding, Element#'s (which are: 10, 11, 12, 13, 14) for each case. I have
findings of Correct, Discrepancy, Error and Drop. What I want to do is, that
if the case is Correct, I don't want to list the Element#'s just the Case
Number, SS#, and Finding.
Click to expand...


Use VBA code in the (detail?) section to make the Element
invisible:

Me.txtElement.Visible = (Me.txtCase <> "Correct")
 
Back
Top