>I have a class, that is setup via these properties.
>I place the fields for an sql query in properties of the combo box.
>In the init of the combo box, I build the sql, and then I execute.
>
>What is happening is this. Since the field is bound to a control source, it is showing whatever that value is. This I want, but...
>I have found the following bug when the table has no records, i.e. all records have been deleted. It displays the first record, even though it is deleted.
>What I would like to do, is it there are no records returned, I would like to display some text, like 'No Data' o 'Empty' to let the user know there is no data as opposed to the above.
>
>Mike
I think in your case you better set it to alias/cursor type instead, have a method to run your SQL, check if there are records in the cursor and add one blank record if there is none.
I think I have a class for this using array as a rowsource, but it looks like having cursor for your case would be easier.
If it's not broken, fix it until it is.
My Blog