>>>Hi Gang,
>>>
>>>A quick question.
>>>
>>>I have a combobox on a form set up with Style of 2 (Combobox Dropdown List).
>>>
>>>I have the Rowsource Type as 6 (fields) and Rowsouce of discount.code,desc
>>>
>>>The discount.code has in the dropdown 6 values. None of them are blank.
>>>
>>>I would like to allow the user to have a blank value to choose from so they can always go back to a default blank value for the discount code ( No discount code).
>>>
>>>Any way to get this blank value to show up in the combolist (since it is Type 6) ?? Or am I stuck to using Type 0 or 1 ?
>
>Is the discount.code used for other purposes? I came at a similar problem from the other direction and simply added a blank value to the code table. This avoided nulls when joined to a lookup table.
Or use something like this for the rowsource..
select ' ' as code, ' ' as desc from discount
union
select code, desc from discount
BTW DESC is a reserved VFP word and it will bite you someday if you try to use cursoradapters or views.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________