How do i check against each value of a list box

  • Thread starter Thread starter Hotshots
  • Start date Start date
H

Hotshots

How do i check against each value of a list box !!!!

I have a list box whose row source is modified based on entry in
another field "IDNO". The list box has two columns "DESC" and "MAXNO" .
I want to check (the checking procedure may be initialised by a command
button) if each MAXNO displayed in the listbox is lower than another
field called "CTRLNO" and displayt a msgbox to that effect !!!

How do i do this???
 
How do i check against each value of a list box !!!!

I have a list box whose row source is modified based on entry in
another field "IDNO". The list box has two columns "DESC" and "MAXNO" .
I want to check (the checking procedure may be initialised by a command
button) if each MAXNO displayed in the listbox is lower than another
field called "CTRLNO" and displayt a msgbox to that effect !!!

How do i do this???
Click to expand...

It's hard to do so checking the listbox itself; a listbox is a data
entry tool, not a data repository! But you can use DLookUp on the
*QUERY* upon which the listbox is based. It's not clear from your
question just what that criterion would be but that's where to look -
in the query, not in the listbox itself.

John W. Vinson[MVP]
 
Back
Top