A
alex
Hello,
using Access '03...
I have a form which contains an unbound listbox. The listbox row
source is a query that sums a value.
The listbox works fine...it displays the appropriate value (I requery
the listbox whenever information changes).
What I cannot do, however, is write code to evaluate the value of the
listbox (null or otherwise).
I've tried writing code that looks for isnull or me.value = N...no
luck.
What i'm looking to do is display a label (or even a msgbox) on the
form when the listbox value is > 5:
e.g., if me.lstHours.value > 5 then
me.lblWarning.visible = true
any help would be appreciated!
alex
using Access '03...
I have a form which contains an unbound listbox. The listbox row
source is a query that sums a value.
The listbox works fine...it displays the appropriate value (I requery
the listbox whenever information changes).
What I cannot do, however, is write code to evaluate the value of the
listbox (null or otherwise).
I've tried writing code that looks for isnull or me.value = N...no
luck.
What i'm looking to do is display a label (or even a msgbox) on the
form when the listbox value is > 5:
e.g., if me.lstHours.value > 5 then
me.lblWarning.visible = true
any help would be appreciated!
alex