A
Ayelet
Hi.
I have a form with a combobox, which generally shows only
products from a certain category, and a command button,
ShowAll, which changes the RowSource property of the
cmbbox control to include all the products. when this is
done, the button's caption changes and when it's pressed
again it goes back to showing only a part of the list.
The problem is that whenever i view any items not from the
smaller list, I get a blank value in the comboBox(because
it's not in the RowSource), until i hit the "ShowAll"
button, and then i have to click each individual combobox
(the form is in continuous forms view, so there can be
quite a lot) to see the name of the product in it.
I think this is not so much a technical problem as an
algorithmic one, still i hope someone could give me a
hint...
10x in advance,
Ayelet
I have a form with a combobox, which generally shows only
products from a certain category, and a command button,
ShowAll, which changes the RowSource property of the
cmbbox control to include all the products. when this is
done, the button's caption changes and when it's pressed
again it goes back to showing only a part of the list.
The problem is that whenever i view any items not from the
smaller list, I get a blank value in the comboBox(because
it's not in the RowSource), until i hit the "ShowAll"
button, and then i have to click each individual combobox
(the form is in continuous forms view, so there can be
quite a lot) to see the name of the product in it.
I think this is not so much a technical problem as an
algorithmic one, still i hope someone could give me a
hint...
10x in advance,
Ayelet