iaasiqbal
New member
- Local time
- Today, 19:47
- Joined
- Mar 30, 2022
- Messages
- 26
Please help to write the condition
IET = Income Expenditure Type
IET = "", "Income", "Expense"
in my data entry form -when IET is blank or null the two field debit & credit will be in visible, and IET = Income the credit field will be visible and debit field is invisible
and IET = Expense the debitfield will be visible and credit field is invisible
Private Sub Form_Current()
If IET = "" Then
DEBIT.Visible = False
CREDIT.Visible = False
If IET = "Income" Then
CREDIT.Visible = True
DEBIT.Visible = False
If IET = "Expense" Then
DEBIT.Visible = True
CREDIT.Visible = False
End If
End Sub
IET = Income Expenditure Type
IET = "", "Income", "Expense"
in my data entry form -when IET is blank or null the two field debit & credit will be in visible, and IET = Income the credit field will be visible and debit field is invisible
and IET = Expense the debitfield will be visible and credit field is invisible
Private Sub Form_Current()
If IET = "" Then
DEBIT.Visible = False
CREDIT.Visible = False
If IET = "Income" Then
CREDIT.Visible = True
DEBIT.Visible = False
If IET = "Expense" Then
DEBIT.Visible = True
CREDIT.Visible = False
End If
End Sub