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

I understand what you mean...but this isn't really my problem. The value isn't really deleted. Here is an example that might help.
In my combobox I have this for the rowsource...
1
2
3

So lets say I pick the value 2....so now the table that is the CONTROL SOURCE has a value of 2....right?

Well..then later the table that is the rowsource is changed...at it just has this:
1
3

So the 2 is still in the table that is the control source, right?

But now...when the form is run...you don't see the 2! All you see is a blank. Now even though they can only select a 1 or a 3...the user still needs to be able to see the 2 because that is the current value of the table that is the control source...SURLY there is a way to do this...I'm tempted to make a textbox on top of the combobox to get around this...but that seems kinda like a lot of work and somewhat insane..heh...

ANYHONE got a way around this?