How do i compare a value for a input field against a value in a column in a listbox.
This is my code but currently nothing happens. I want to make sure drawdownamt(input field ) does not exceed the list box's column 4 amount.
Both are in the same form
Code:Private Sub DrawdownAmt_BeforeUpdate(Cancel As Integer) If Me.DrawdownAmt > Me.ListFacility.Column(3) Then MsgBox ("WARNING:You have entered an amount larger than total amount!") Cancel = True Me.DrawdownAmt.Undo End If End Sub