Sorry, I must have messed up. It does work now. Thanks

>What do you mean by that? The RowSource tells the combo how to populate its internal list. The ControlSource tells it which field in which table to replace with the value selected from the RowSource.
>
>What you have said here ,akes no sense to me.