Combo Box Source

[Kib]

Hi, I have a combo box, and it references a query. Long list of things. But I just want there to be two additional text items shown at the top in addition to the query. IE (ALL, NONE) how do I add these list items into my combo box? Thanks

 

[Rolliee]

Unless they show up in the query, they cannot be easily shown on the combo box. Although one way might be to use the Values List on the combo box and build a string that would start as follows:

"All;None;FieldValue1;FieldValue2 .....etc "

This string could then be plugged into the data source of the combo box.

This means the wiz will not handle the finding or pointing in the normal way but this is a "way to do what you ask" If you need further help, just verbalize and ask.

rollie@bwsys.net

 

[natatbh]

Hi Kib,

Use a UNION query. IE "your query UNION query for ALL, NONE"

natatbh