How to compare amounts between input field and listbox?

[xwnoob]

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

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

[June7]

Is selection of item in listbox done first?

Step debug, what value is shown for the listbox variable in the code?

Refer to link at bottom of my post for tutorial on debugging techniques.

[xwnoob]

Edit: i want to select the 6th column so the code would be like this:

Private Sub DrawdownAmt_BeforeUpdate(Cancel As Integer)
If Me.DrawdownAmt > Me.ListFacility.Column(5) Then
MsgBox ("WARNING:You have entered an amount larger than total amount!")
Cancel = True
Me.DrawdownAmt.Undo
End If
End Sub

I forgot to mention the listbox is a cascaded listbox,where it displays info depending on another listbox.

im trying to use the locals window or the immediated window to debug but i cant see any variable values? My code is not a macro so can it still be executed step by step??



Edit: I tried storing the values into variables and it worked.....

Dim ListFacility As Single
Dim drawdwnamt As Single


ListFacility = Me.ListFacility.Column(5)
drawdwnamt = Me.DrawdownAmt


If drawdwnamt > ListFacility Then
MsgBox ("WARNING:You have entered an amount larger than total amount!")
Cancel = True
Me.DrawdownAmt.Undo
End If


however should i DIM the variables as single or doubles?

[June7]

Review that debug tutorial. Look at the sections on Breakpoint and Stepping. When code pauses, hover cursor over variables (like the listbox reference) to see the value.