Listbox problem

#1

This seems like a silly little problem that ought to have a simple
solution... but I've searched in vain for one.

Among the various controls on a form, I have a combobox which, when
updated, changes the rowsource of an adjacent listbox. What I then want
to do then is select the first item in the listbox. This I can do by
using Me!Listbox.Selected(0) = True, but when I do this, the form
pretty much stops responding - I can no longer click on any of the
other controls in my form. I can still click on the aforementioned
combobox and select new items from it, but I can't click on any of the
other comboboxes in the form, nor can I tab to them with the keyboard.
I've tried using setfocus to move the focus onto some other control but
this brings up 2110 run-time errors.

If this problem rings a bell with anyone, I'd be unspeakably grateful
for any tips...

Jim.

#2

jimphiggins (AT) yahoo (DOT) co.uk wrote:

Quote:

This seems like a silly little problem that ought to have a simple
solution... but I've searched in vain for one.

Among the various controls on a form, I have a combobox which, when
updated, changes the rowsource of an adjacent listbox. What I then want
to do then is select the first item in the listbox. This I can do by
using Me!Listbox.Selected(0) = True, but when I do this, the form
pretty much stops responding - I can no longer click on any of the
other controls in my form. I can still click on the aforementioned
combobox and select new items from it, but I can't click on any of the
other comboboxes in the form, nor can I tab to them with the keyboard.
I've tried using setfocus to move the focus onto some other control but
this brings up 2110 run-time errors.

If this problem rings a bell with anyone, I'd be unspeakably grateful
for any tips...

Jim.

Is it a multiselect listbox? If not, you could do me!Listbox.listindex=0

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

#3

Me.Listbox.Value = Me.ComboBox

Darryl Kerkeslager

<jimphiggins (AT) yahoo (DOT) co.uk> wrote:

Quote:

This seems like a silly little problem that ought to have a simple
solution... but I've searched in vain for one.

Among the various controls on a form, I have a combobox which, when
updated, changes the rowsource of an adjacent listbox. What I then want
to do then is select the first item in the listbox. This I can do by
using Me!Listbox.Selected(0) = True, but when I do this, the form
pretty much stops responding - I can no longer click on any of the
other controls in my form. I can still click on the aforementioned
combobox and select new items from it, but I can't click on any of the
other comboboxes in the form, nor can I tab to them with the keyboard.
I've tried using setfocus to move the focus onto some other control but
this brings up 2110 run-time errors.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Listbox problem

comp.databases.ms-access comp.databases.ms-access

Listbox problem - 12-17-2004 , 10:29 AM

Re: Listbox problem - 12-17-2004 , 11:33 AM

Re: Listbox problem - 12-17-2004 , 04:38 PM