Hi Marcia,
Interesting... Thanks for the tip
(I thought I had tried it and it wouldn't let me do it - oh well learn a new thing every day!)
Thanks
Will
>Hi Will.
>
>>> If the combo is in a grid you should not be able to set the controlsource anyway (it's forced to be the same as the grid's column data) <<
>
>Actually, this is not true. I use a trick all the time to have drop down lists in my grids with column.sparse = .T. where I set the column controlsource using an ( IIF( SEEK.... ) ) and then set the combo's control source to the foreign key in a lookup table.
>
>Marcia
Will Jones