Can only select first row in list box

[sohunter]

Yes, this must be a simple problem, but I can't seem to find the solution. I've put a list box on a form based on a separate table. There are multiple rows in list box, which is what I expected, but I can only select the first row. I don't need multi-select, just the ability to scroll/tab down through rows and select one row of your choosing. I've set multiselect property to None.


Any thoughts?

 

[markgrizzle]

sounds corrupted. delete the listbox from your form, then rebuild it. be sure to cut/paste any code behind it to notepad first.

 

[sohunter]

Hm.... no, that didn't work. Thanks though.

 

[sohunter]

Perhaps this has to do with the fact that there's no control source... which leads me to the fact that maybe I'm using the "wrong tool for the job."

What I'm trying to do is just display a list of categories for a particular agency (on a form.) This is an "end user" version of db, so user doesn't really "select" anything. (The list is coming from a relate table, and picks up all categories that are associated with the current agency.)

The thing is, it's going to be used by the blind (with JAWS, a screen reader) so if user tabs into this field, I want them to be able to tab/arrow down through the list to read all possible categories that an agency might belong to.

A subform works as well, but in the world of tabbing (which is what blind users are doing a lot of) you have to press control tab to get OUT of a subform, which I'd like to avoid.

What might work best I suppose, for JAWS users, is just a text field that gets it's text (a comma delimited list) from code that runs a query on the relate table. Guess I've got my work cut out for me...

Sorry if I've bored (or confused!) anyone here, but perhaps someone has seen a similar situation...

 

[markgrizzle]

You should be able to populate a listbox from a value list without any problem. How did you enter the list?

"Category";"Date Added";"Format";"Isbn";"License";"Price";"Pub Date";"Pub Season";"Release Date";"Series";"Status";"Title";"Trim Size"

This is an example form one of my forms.

 

[nettie205]

I think what you might do is change it from a list box to a combo box and then select thru a query in the properies sheet what is needed for your lookup table. Make sure in the query, right click and select properties, values are unique.