I have a subquery that displays a list of options in a combobox. I need the combobox to show hte stored value of a record but when the users selects the pull down portion of the combobox I need the list to be complete. The list only shows the items form the stored date forward.

The example is I have three possible answers for the combobox, the values are 0, 1, 2. IF teh stored vlaue is 2 then only option 2 is available, if option 1 is stored then only option 1 and two are available.

Ive been round and round with this today so if anyone has an idea, I would appreciate it.

<td><select name='EIOCustody' id='EIOCustody'
{SUBQUERY,
Name='EIOcustQry',
Query="Select comboBoxDesc as Custo, comboBoxItem as CustoCatId from combobox
where comboboxgrp='InterestedOthers' and combobox='Custodianship' and isactive=1 order by CustoCatId ASC",
Format="<option value=[CustoCatId]>[Custo]</option>",
SelectedFormat="<option value=[CustoCatId] SELECTED>[Custo]</option>",
SelectedField="CustoCatId",
SelectedItems="[FORMAT,[EIOCustody,form].{ISEMPTY:[Custodianship]}]",
UseCache="False"}
</select>

Well, no matter what I tried I could never get the combobox to display more than two resutls. Switching to a radio button list displays all results, however. Here is the code for any who might be interested (extra spaces added to try and fool the forum parser).

<t r> <t d>Custodianship </t d>
<t d> {SUBQUERY,
Name='EIOcustQry2',
Query="S e l e c t cb.comboBoxDesc as Custo2, cb.comboBoxItem as CustoCatId2 from elementsdemo.dbo.combobox cb
where cb.comboboxgrp='InterestedOthers' and cb.combobox='Custodianship' and cb.isactive=1",
Format="<i n p u t type='radio'
name='EIOCustody'
id='EIOCustody'
value='[CustoCatId2]'
\{i i f,[custodianship]=[CustoCatId2],checked,\}>[Custo2]",
,
,
,
UseCache="False"}

</t d>
</t r>