On Current

[mohammadagul]

in my OnCurrent of Invoice form i am trying to put the following Code

If Me.Invoice.Value = True Then
Me.InvoiceNumber.Visible = False
Me.ManualInvoiceNo.Visible = True
Else
If Me.Invoice.Value = False Then
Me.InvoiceNumber.Visible = True
Me.ManualInvoiceNo.Visible = False
End If
End If
End

If Me.InvoiceBalance.Value > 0 Then
Me.FullyPaid.Value = False
Else
If Me.InvoiceBalance.Value = 0 Then
Me.FullyPaid.Value = True
End If
End If
End

the problemd is that when the form is run the current event only fulfills the first code and not the second one. i tried changing the order i.e placed the second code first, even then it is only accessing the first code. how can i make both work together.

 

[___]

Try...

     If Me.Invoice.Value = True Then
          Me.InvoiceNumber.Visible = False
          Me.ManualInvoiceNo.Visible = True
     Else
          Me.InvoiceNumber.Visible = True
          Me.ManualInvoiceNo.Visible = False
     End If

          If Me.InvoiceBalance.Value > 0 Then
               Me.FullyPaid.Value = False
          Else
               Me.FullyPaid.Value = True
          End If

 

[Mile-O]

This code should do the exact same thing.

Me.InvoiceNumber.Visible = Not Me.Invoice
Me.ManualInvoiceNo.Visible = Me.Invoice
Me.FullyPaid = Not Me.InvoiceBalance > 0