Pls, I'm writing a data-centrc application with a requirement to have a popup on a column, of a datagrid, that's a foreign key to another table; such that when a cell in the column has focus the user either types a value in this cell or request a popup to be displayed and the code of the selected value to appear in the cell.

Thanks soccers_guy10. It's still better late than never. I was programming in VB6 when I posted this problem but since moving to VS2008 I've got new challenges like printing a richtext formatted data that's in one of the columns retrieved from an MS SQL Server 2005+. I found out there is no matching MS Reporting control to render a RichText data. I'm thinking of exporting the data to MS Word and building the report grids thereto.

Well if anyone has a better idea please let me know. Please don't suggest buying any components like DevExpress suites (yeah! great product set; not for now).

Create your own DataGridColumnStyle
The idea is create usercontrol which inherits from DataTextboxColumn or some controls more useful and add a little button to show look up data dialog.

Yeah, I've used that method to display a datetimepicker in the gridview but I was programming in VB6 then. But VS2005 and then VS2008 have changed the goal post and there are more challenges like a RichTextBox column style...And how to have that rendered with an MS Report Writer.