>I have a combobox that is using a table as the rowsource. On occasion the contents of this table can change and a few of the items that were there have been deleted, thus changing what appears in the drop-down-list. Well, now when this combobox's control source indicates that it should be displaying one of the items that has been deleted...it shows up blank instead of showing the value. Seems like this is a pretty typical thing that you'd want to be able to do...am I missing something obivous here?
>Thanks!
If the controlSource is set to a non existent record in the rowsource then yes it will show a blank in the combobox (this is so you can type in a new entry if you want)
What would you want the combobox to display in this situation? maybe the first value in the list?
If you really want to see the deleted record then you could change the value of Set deleted
HTH
Will Jones