>>>>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

Very good!

>
>BTW DESC is a reserved VFP word and it will bite you someday if you try to use cursoradapters or views.

Egads!!!! I overlooked DESC.... well, guess what I will be doing for the next hour or two... sigh.....