Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need If based on 2 conditions HELP!!! Please. 1

Status
Not open for further replies.

Majie2

Technical User
Jul 24, 2003
3
US
I have a form that is for distributions. The distribution code is a text box and I have four check boxes that I need to know how to check or not check based on two text boxes. I have a text box for the IRS distribution code, le..1 is a cash distribution and the text box BRI code would be a D. and that means that the checkboxes for cash and 20% taxes would be checked but If the bricode is H for an hardship then the checkbox for cash would be true and the checkbox for 20% tax would be false. I have been racking my brain!! Please help. This would really help with accuracy in my department. Thank you in advance.
Jamie
 
If you have two check boxes called chkCash and chkTax and a text box called txtBRICode you could put this in the Change event of the text box
Code:
Private Sub txtBRICode_Change()

    Select Case txtBRICode
    Case Is = "D"
        chkCash = True
        chkTax = True
    Case Is = "H"
        chkCash = True
        chkTax = False
    Case Else
        chkCash = False
        chkTax = False
    End Select
    
End Sub

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)
 
That got me on the right track..Thank you!!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top