>I have a combobox that takes its value from a cursor, except that it is OK for the field to be empty. Other than adding a blank record to cursor, how can it be done?
>
>Also, the help for recordcount property indicates that -1 is the default value which means use all columns, I believe... but -1 is illegal! 0 is the default. Is this a typo in the help?
>
>Alex
One way would be to use a UNION clause for either cursor or SELECT SQL for RecordSource, e.g.
select space(4) as code, padr("<Blank>",20) as Description from myLookup;
union ;
select code, Description from myLookup ;
order by 2
Another way would be to allow combo to create an empty entry by, say, right click. You would use blank field myfield in myTable.
If I'm not mistaken, Dragan had a thread about it several months ago, you may want to search by his ID...
If it's not broken, fix it until it is.
My Blog