>Bill --
>
>Would a list box or combo box work for you? The control itself would perform the lookup. Depending on the display and behavior you want, you may want to look at the ColumnCount, BoundTo and BoundColumn properties.
>
> Jay
>
P.S. and also the RowSource and RowSourceType properties. You may just want to use the table itself.