Tupacmoche
Registered User.
- Local time
- Today, 08:14
- Joined
- Apr 28, 2008
- Messages
- 291
Hi Report Experts,
I have a payment section(not a band) in the detail section that shows pay by Check, Cash, Wire, ect. Since, payment can be made by any of these methods and others, I have placed all the payment methods under a text box that reads "Payment Information". I have set the visibility property to false in vba code, for example: CheckNum.Visible = False. Now, I have a case statement that changes visibility to True if that payment method is stored on the current row. Here is the code:
Select Case GiftHowPay
Case "Check"
Me.GiftCheckNo.Visible = True
Me.GiftRecptDt.Visible = True
Me.GiftCkAmt.Visible = True
Case "Cash"
Me.GiftCashAmt.Visible = True
Case "Credit Card"
Me.GiftCreditCardNum.Visible = True
Me.GiftNameonCard.Visible = True
Me.GiftCardExpDt.Visible = True
Case "Wire (EFT)"
Me.GiftWireAmt.Visible = True
Case "Securities"
Me.SecStockName.Visible = True
Me.SecTicker.Visible = True
Me.SecNumofShares.Visible = True
Me.SecHigh.Visible = True
Me.SecLow.Visible = True
Me.SecAve.Visible = True
Me.SecValue.Visible = True
Case "Pre-deposited"
Me.GiftPredeposited.Visible = True
End Select
Now, to the problem. When, I open the report Check visibility is set to True since GiftHowPay = Check in the first record. But as I move from row to row the other payment types don't become visiable like Cash, Wire, ect. All this code is in the report_Load() event procedure. What do, I do to make this work?:banghead:
I have a payment section(not a band) in the detail section that shows pay by Check, Cash, Wire, ect. Since, payment can be made by any of these methods and others, I have placed all the payment methods under a text box that reads "Payment Information". I have set the visibility property to false in vba code, for example: CheckNum.Visible = False. Now, I have a case statement that changes visibility to True if that payment method is stored on the current row. Here is the code:
Select Case GiftHowPay
Case "Check"
Me.GiftCheckNo.Visible = True
Me.GiftRecptDt.Visible = True
Me.GiftCkAmt.Visible = True
Case "Cash"
Me.GiftCashAmt.Visible = True
Case "Credit Card"
Me.GiftCreditCardNum.Visible = True
Me.GiftNameonCard.Visible = True
Me.GiftCardExpDt.Visible = True
Case "Wire (EFT)"
Me.GiftWireAmt.Visible = True
Case "Securities"
Me.SecStockName.Visible = True
Me.SecTicker.Visible = True
Me.SecNumofShares.Visible = True
Me.SecHigh.Visible = True
Me.SecLow.Visible = True
Me.SecAve.Visible = True
Me.SecValue.Visible = True
Case "Pre-deposited"
Me.GiftPredeposited.Visible = True
End Select
Now, to the problem. When, I open the report Check visibility is set to True since GiftHowPay = Check in the first record. But as I move from row to row the other payment types don't become visiable like Cash, Wire, ect. All this code is in the report_Load() event procedure. What do, I do to make this work?:banghead: