var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Filling ComboBox
On the top of my form I have an option group with 3 options, lets call them a, b and all.
On the form I have a combo box. I would like the combobox to be filled with data, depending on the fact whether I select option a, b or all.
So If I select a, I would like to run Query a and fill the combo box with its data. The same of course for b and all.
How would I be able to do that? Is there a wizzard that can provide help?
Use the RowSource of the comboBox in a SELECT CASE Statement
SELECT Case chk
Case = 1
yourComboBox.RowSource="SELECT * FROM yourTable1;"
Case = 2
yourComboBox.RowSource="SELECT * FROM yourTable2;"
Case = 3
yourComboBox.RowSource="SELECT * FROM yourTable3;"