listbox doesn't store value

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

Jean-Paul

Hi,

I have a listbox named "ValuesA"
It contains values like: 5 10 15 20 25

I can scroll through te values without any problem but when I actualy
want to "do" something with the value I get an error saying there is an
illegal use of Null.

When I ask for the current value I get a Null

So, I think, scroling trough the listbox isn't enough to really "GET"
the value...

What can I do to store the value only by scrolling through the listbox?

Thanks
 
Hi Jean-Paul,

"When I ask for the current value I get a Null"

have you clicked on a value to pick it?

also, is your listbox set to allow Multi-Select? If so, you cannot
simply refer to the listbox to get its values, you must loop through
what is selected

"What can I do to store the value only by scrolling through the listbox?"

someone may have written code to do this -- but I do not have any
example. The standard method is to click, not simply scroll


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Back
Top